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.
double quotes in the field values.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.