row delimiter in column values

sk39758 · Post by **sk39758** » Mon Mar 14, 2011 10:51 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 14, 2011 10:55 pm

Are the columns quoted?

sk39758 · Post by **sk39758** » Mon Mar 14, 2011 10:59 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 15, 2011 12:43 am

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.