BizTalk Server Tools - Issue with creation of Format Description for flat file with line numbers.

Author

Issue with creation of Format Description for flat file with line numbers.

Asad Enait

2004-05-15, 10:35 am

HI All,

I am trying to develop the Format description to convert a flat file
to XML.

The flat file is with multiple record type.

Issue is each line ( record) starts with aline number,
Like below:
1,"A","D002","JS","AUS","","56072528600","","01000000","",20030813,0922,""
2,"H","D0547689",20030813
3,"D","","D30869","","TWIST WHISK BD/HAPPY DOG"
4,"D","","D30870","","TWIST WHISK H /HAIR DAY"
..
..
9,"T","D0547689",6,59.400,5.400,
10,"Z","JS","01000000",6,59.400,5.400

When I assign the id. for a record (A, H, D etc), the system is only
looking at the fist field, which is a line number.

Is there any way I can skip the first field and use second fiel as the
record id?

Please help

Thanks,
Asad