Flat file

20 Views

Hi

I have a flatfile with header & line items,i have done the flat file conversion to identify header & line items

Flat File

*************

001151,2006,KR,09012006,09062006,09,4401-0806,USD,001,001151,31,K,S,00000000011495,44010806,034354401,0

000041531,,,09062006,C,,015N,Time Warner Cable,,,,US,,,,

,,,,,,,,002,001151,40,S,H,00000000011495,,*034354401,0000738100,0000006086,,,,,,,,,,,,,,

001150,2006,KR,08252006,09052006,09,8478723006,USD,001,001150,31,K,S,00000003288319,8478723006,171787591

7 383,0000034713,,,08252006,C,0009800357,015N,AT&T,,,,US,,,,0009800357

,,,,,,,,002,001150,40,S,H,00000001000000,,*1717875917 383,0000738100,0000007320,,,,,,,,,,,,,,

,,,,,,,,003,001150,40,S,H,00000000688319,,*1717875917 383,0000738100,0000005600,,,,,,,,,,,,,,

,,,,,,,,004,001150,40,S,H,00000000500000,,*1717875917 383,0000738100,0000005800,,,,,,,,,,,,,,

,,,,,,,,005,001150,40,S,H,00000001100000,,*1717875917 383,0000766410,,000000500049,,,,,,,

********************************

My line items starts with first 7 columns with no values the ex: ,,,,,,,001 is my first line item

In my output i am not getting line items but if i define some values in first 7 colums i am getting output.

Can any one please tell me what would be the problem here...

Thanks

sriram