If I understand right, you get data in and EDI file (Electronic data interchange). The the end of record symbol (in this case) is the paragraph marker.
You can open the .edi file in Word and do a replace - replace the paragraph marker with a manual line break. In VBA, replace the paragraph marker with a CRLF.
You also have to know the structure of the .edi file. I do not see any separators - tabs, commas, etc. to show the start/end of a field.
Using VBA, you can read each character until you get to the paragraph marker. Then process the line, breaking it up into the fields you need. Then read more characters until you get to the next paragraph marker.
I did the replace to see what the structure/data looked like:
Code:
ISA`00`FTL DATA `00`FTL DATA `ZZ`FTL MFG `ZZ`HE10 MFG `121124`1725`U`00401`000001285`0`P`>
GS`PO`FTL MFG`HE10 MFG`121124`1725`1260`X`002000
ST`830`000020932
BFR`05``000199`SH`A`121124`130523`121124```A05025072
N1`BY`FTL
N1`SE`HE10
LIN`001`IN`87330-3438`EC`-
UNT`EA
J2X``F`JUNCTION BOX ASSEMBLY W/ COVER
N1`ST`TMP`92`001
SDP`A`A
FST`1`C`D`121206
ATH`FI`121221
SHP`02`47`051`060131``121124
SHP`01`4`050`110930
LIN`002`IN`87330-3438`EC`-
UNT`EA
J2X``F`JUNCTION BOX ASSEMBLY W/ COVER
N1`ST`MTH`92`017
SDP`A`A
FST`0`C`D`121124
ATH`FI`121221
SHP`02`1`051`060131``121124
SHP`01`1`050`091215
LIN`003`IN`87330-3438`EC`-
UNT`EA
J2X``F`JUNCTION BOX ASSEMBLY W/ COVER
N1`ST`UTR`92`058
SDP`A`A
FST`4`C`D`121107
FST`5`C`D`121108
FST`6`C`D`121115
ATH`FI`121221
SHP`02`3257`051`060131``121124
SHP`01`4`ZZ3`060131``121124
SHP`01`9`050`121123
LIN`004`IN`87330-3438`EC`-
UNT`EA
J2X``F`JUNCTION BOX ASSEMBLY W/ COVER
N1`ST`SAN`92`065
SDP`A`A
FST`0`C`D`121124
ATH`FI`121226
SHP`02`56`051`060131``121124
SHP`01`5`050`100428
CTT`4`16
SE`45`000020932
GE`1`1260
IEA`1`000001285
But I can't break it up into fields. We need more info.....