double quotes in the field values.

[kollurianu]

Hi All ,

I have file csv with double quotes and the data is as below ,

Though the format in datastage job is given as

Delimiter=,
quotes=double

For two of the fields Misc Description and Security description ,when the data is viewed thru datastage browser the values still contain double quotes. Because of double quotes in the values when substringed and checking for some value it is giving wrong values , so how can this be resolved.

It should be as below ,
for example abcd[1,2]="ab" instead
"abcd"[1,2]will never be equal to "ab"
as "abcd"[1,2]="a




Original file data is as below.

Currency,Client ID,Fund,Security Name,Settled/Original Face,Current Face,Local Mkt Price,Local Mkt Value,Settle Loc,As Of Date,CP Cusip,Fund Name,Isin,Mainframe Time Stamp,Misc Description,PPN,Price Date,Redenomination sw,SS Asset ID,Security Description
"CAD - CANADIAN DOLLAR","NFMM","NFMD","CANADA GOVT",1040000,0,105.19,1094017.6,"CAN - CANADA",11/04/2008," ","4025 COVERAGEONE CORP","CA135087YN80",11/04/2008 11:36:00,"3.5PCT 01JUN13"," ",10/04/2010,"N","135087YN8","3.500000% 01 JUN 13"


Thank you,
Purna Kolluri.

[ray.wurlod]

Can you use a server job (or even a server Shared Container in the parallel job)? Parallel job Sequential File stage has ... problems ... with embedded quotes. Server job Sequential File stage is far better at handling them.