Page 1 of 1

How to read the complex text data

Posted: Wed Nov 16, 2011 9:22 pm
by rameshkm
Hi Experts,

I am having an input data as follows

col1 1,2,3,4,5,6,7,8....
col2 qa,ee,rrrr,fff,wds,r,fff,.....

while i tried to read this data with sequential stage its throwing error as "consume more than 10000 bytes looking for record delimiter, aborting"

Could you please suggest me which stage I have to use with some examples.

Thanks in advance

Posted: Wed Nov 16, 2011 9:45 pm
by qt_ky
Is that exactly the what the file content looks like or is it like this:

1,"qa"
2,"ee"
etc.

Go into the format tab on the sequential file stage and set quote characters and delimiters and record delimiters to make them match the layout of the file.