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
HDR CANNOT READ THIS
BEG
CURYEN
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.
John,
Based on your requirement create the FF Schema using this way.
FlatFileDefinition Tab:
In the Record Parser select “Delimiter”, with Record Character set to either “newline or Carriage Return”.
FlatFileStructureTab:
Create RecordDefinition HDR and set this to “Unlimited” since this will have multiple instances as you said and create FieldDefinitions in your case it is fixedlength data(specify Start/End length) and under the same hierrachy create BEG record defintion and create corresponding FieldDefinitions with fixedlength positions and similarly create record definition for CUR and respective field definitions.
Fially Test your flatfile schema using some .txt file providing under the Test tab.
HTH,
RMG
RMG,
Setting it to “Unlimited” did the trick.
Thanks for your help!
John