File Conent Conversion - Finding a specific sequence

[Former Member]

Hi there

I would like to know, is it possible with fcc to set the endSeparator's value to the first 2 char of each line, and if it stars with some value it's a new record?

Eg. If I have:

012938489

029786789

029979748

01 would be the header and 02 would be the body of the record. But it can contain multipe 01's and 02's so I have to check if it starts with 02 it must create a new node in die xml..

Hope this makes sence.

Regards,

Jan

[Former Member · Accepted solution]

Hi Jan

Yes This is possible, to implement a Scenarion like this in the FCC set the following:

Record Set Structure: HEADER,,ITEMS,

Then in the Table

HEADER.fieldNames = ID,REST

HEADER.fieldFixedLengths = 2, 7 (This is the lengt of filed below)

HEADER.keyField=01 (Identifies a new header Line)

ITEMS.fieldNames = ID,REST

ITEMS.fieldFixedLengths = 2, 7 (This is the lengt of filed below)

ITEMS.keyField=02 (Identifies a new header Line)

<RecordSet>

<HEADER>

<ID>1</ID>

<REST>FB01</REST>

</HEADER>

<ITEMS>

<ID>02</ID>

<REST>9786789</REST>

</ITEMS>

<ITEMS>

<ID>02</ID>

<REST>9979748</REST>

</ITEMS>

</LINE_ITEMS>

</RecordSet>

Thanks

Damien

[Former Member · Accepted solution]

Hi again,

Thanks! Most of the blogs shows exacly what to do but not what they are doing. lol

Regargs,

Jan

[Former Member · Accepted solution]

Welcome