Hi ,
I have a file for which row delimiter is enter (ascii value 13) .
Unfortunately enter (ascii value 13) is appearing in one of the column value as well.Bcoz of this some of the are getting rejected.Could some one tell me how to handle this situation.
Please let me know of you need any other information.
row delimiter in column values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes columns are quoted. If you want I can paste a sample row for you.
ID,NAME,TYPE,BILLINGSTREET,BILLINGCITY,BILLINGSTATE,BILLINGPOSTALCODE,BILLINGCOUNTRY
0012000000301zJAAQ,xyz,Licensee,"Level 1
464 High Street",Prahran,VIC,3163,AUS
first row is columns names and second row is actual data.
There is one enter(ascii value 13) after "Level 1. That's why rest of the data is appearing in next row.
ID,NAME,TYPE,BILLINGSTREET,BILLINGCITY,BILLINGSTATE,BILLINGPOSTALCODE,BILLINGCOUNTRY
0012000000301zJAAQ,xyz,Licensee,"Level 1
464 High Street",Prahran,VIC,3163,AUS
first row is columns names and second row is actual data.
There is one enter(ascii value 13) after "Level 1. That's why rest of the data is appearing in next row.
Last edited by sk39758 on Tue Mar 15, 2011 12:44 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a server job, or a server Sequential File stage in a server Shared Container that you can put into a parallel job. This stage has a "contains newlines" property that's not available in its parallel equivalent.
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.