How to define subfields in character delimited flat file template

, ,
1

Hi,
I need to parse a non-standard version of EDIFACT file in WM4.6. To do the same, I have created a template (for delimited file) and invoking the services stringToDocument, documentToRecord and convertToValues resp. It is creating the IData object but not able to identify the sub-fields.
For eg,
I have defined the sub-fields in the template using SUB-POS tag as
…
…
<sub-field-delimiter>
<fixed>:</fixed>
<keyword></keyword>
<offset></offset>
</sub-field-delimiter>
<segment>
<field>
<field>
<field>
…
…
…
If I pass the data as UNB+UNOA:1+221 for the above fields, the output is coming as
SyntaxIdentifier - UNOA:1
SyntaxVersionNumber - UNOA:1
InterchangeSenderIdentification - 221

In this example, SyntaxIdentifier and SyntaxVersionNumber are sub-fields and should get populated with the values UNOA and 1.

How should I define sub-fields in a template? Please help…

Thanks in advance
Anindita

2

Anindita,

I believe this below syntax should work when you have defined correctly uppercase in the template.

<sub-field-delimiter>
<fixed>:</fixed>
<keyword></keyword>
<offset></offset>
</sub-field-delimiter>
<segment>
…

So convertToValues will parse as expected.

HTH,
RMG.