EDI segment delimiter

, ,
21

Glad you understand and it worked.

22

I am trying to crate a FF shcema to parse this file with 2 records, with “HDR” marking the beginning of each:

HDRM0TXN BLAH860OUT
BEG00CP489000 3
CURUSD
HDRM0TXN BLAH860OUT
BEG00CP489000 3
CURUSD

In Developer, the only way I got it to partially work is to set the Record Parser to “Delimiter”, with Record set to “Carriage Return and Line feed”. But the problem is that I will return errors on the second HDR.

Thoughts?
Thanks.

23

Hi John,
When you create the schema for the flat file, go to the Flat File Structure tab. Click on the highest level record. Below you can see properties pane. In that, change the Max Repeat to “Unlimited” or the limit to which it can repeat.

Hope it solves you problem.
Sachin