EDI MAPPING

[Volkmaniac]

Has anyone ever tried to write a script to do EDI mapping?
I attempted to output and parse some records but the looping structure makes it difficult.

ISA|00| |00| |ZZ|USCR USCR004 |ZZ|XXXXXXXXX |040302|1932|U|00306|001149551|0|P|~
GS|FC|USCR USCR004|XXXXXXX|040302|1932|239|X|003060
ST|175|239001
BGN|00|183256-136-7|040302
CDS|7|B||04-10682-MWV||FC|NH|FD|1
LS|CED
CED|N||9A
DTM|519|040301
NM1|TO|3|XXXXXXXXXX XXXXXXX XXXXXXX
N3|201 WEST GRAND AVE.
N3|XXXXXX XXXXXXX XXXXXXX
REF|J1|1426877
NM1|XB|1|THIBODEAU|NORMA|J.
N3|129 SHORE DRIVE
N4|SALEM|NH|03079
REF|SY|018-48-1362
REF|23|1
NM1|XC|1|STEIN|RALPH
N3|68 N. BROADWAY
N4|SALEM|NH|03079
REF|23|1
PER|KP||TE|(603)893-4334
NM1|TY|3|NOTINGER|STEVEN
N3|DONCHESS & NOTINGER PC
N3|402 AMHERST ST., SUITE 204
N4|NASHUA|NH|03063
REF|J4|1
PER|IC||TE|(603)886-7266
NM1|KL|1|VANNAH|GEORGE|A.
CED|AS|NP
CED|P|SL
DTM|656|040604
LM|UC
LQ|J6|ODD
LQ|J6|OD
CED|H|SL|9A
DTM|657|040405|1000
LM|UC
LQ|J1|FM
NM1|XG|2
N3|ROOM 122, FIRST FLOOR
N3|NORRIS COTTON FEDERAL BUILDING
N3|275 CHESTNUT STREET
N3|FIRST FLOOR - ROOM 122
N4|MANCHESTER|NH|03101
CED|CL|NS
LE|CED
SE|46|239001
GE|1|239
IEA|1|001149551

 

[knob]

Not familiar with EDI myself, but could you use strtok to get the first part of each line, then use a switch/case structure to branch to the appropriate code or procedure based on the beginning data of each line?


aspect@aspectscripting.com

http://www.aspectscripting.com

 

[Volkmaniac]

Thanks. I didn't think of it that way. I can use case statements to handle the different conditions.

Thanks again.