PeopleSoft Wiki

Hi All,
I have the below requiremnet to add DESCRLONG column to the Input File(CSV) to load data from SQR to Job code Table,but there could be special character (Comma) ‘,’ in the DESCRLONG Column, So when I am trying to read data from CSV,it is treating ‘,’ (comma) in DESCR LONG Column as delimiter and remaining part after the Comma is getting assigned to the Next column.

I tried many ways to read the DESCRLONG column as single but unable to fix the Issue.

In File layout(People tools) ,there is option for the Field to Format for the above issue like where we can specify Delimiter (Double quotes) if a field value contains comma, I tried this way also but in SQR it is not working .

With the below code in the SQR, when it encounters ‘,’ in the Input file, it is treating as separate column

unstring $Record by ',' into $Add-Chg-Ind $Setid $Jobcode $Effdt $Status $Descr $Descrshort $Job_Function $Descrlon.
Cany anybody suggest on this?

Thanks in advance,
Sudha…

Hi,

I am having an issue while writing the data from SQR to CSV, the DataBase data is used "Enter" while entering data and from SQR to CSV it should be in single cell.
Can someone have solution please?

Thanks a lot.