Sequential file Read

edison · Post by **edison** » Thu May 10, 2012 8:46 am

Input

0001
0002
0003
0001,0002
0005
0003,0004

Source is sequential file and Pipe delimiter, how can we read source data if it like 0001,0002 in 1 line.

When i read source file it is unable to read after comma.It is reading all 6 lines data but not after comma data.

chulett · Post by **chulett** » Thu May 10, 2012 9:13 am

So... when you say "in one line" you actually mean "in one column", yes? And are you certain you set the delimiter to a pipe in the stage? I'd also be curious what the data type of this column is...

edison · Post by **edison** » Thu May 10, 2012 9:36 am

Datatype is Varchar(10), yes i mean one column.

chulett · Post by **chulett** » Thu May 10, 2012 9:46 am

And the pipe delimiter? I'm not sure off the top of my head why you'd be seeing the behaviour you are describing unless the delimiter was set to a comma in the stage.

edison · Post by **edison** » Thu May 10, 2012 9:53 am

Thanks Craig, you are right i set delimiter to comma instead of pipe.

chulett · Post by **chulett** » Thu May 10, 2012 10:27 am

So, resolved?