05-15-04 03:35 PM
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
[ Post a follow-up to this message ]
|