EDI Import issues

Look closer at the example I provided. The idea is to use a set of rules to mark every row. It can be a section start/end, block start/end, record start/end, or a particular field. Once you mark every row, then you can use various actions in EasyMorph to transform data accordingly. For instance, create columns, concatenate rows inside records, etc.

You didn’t provide any description of the file format nor the expected output, so I can only guess what the file structure is. Records clearly have sub-records as I can see multiple ‘GP’ inside some records separated by ‘NMF’. Also, the 1st line is probably the file header and the last line in the file footer.

In the project below, you can see how a record’s start/end is marked. If there are subsections inside a record, they should be marked in a similar way. Once you marked up the entire file, you can start converting individual rows, or groups of rows into columns.

All in all, parsing the file is clearly doable with EasyMorph.

parser.morph (5.4 KB)