Sender Content Conversion with ; endSeparator

[Former Member]

Hi

I'm trying to read the following flat structure using a File Sender communication channel using Content Convesion.

11,99;22,99;33,99

This should be translated into:

<Employees>

<employee>

<employeeNumber>11</employeeNumber>

<employeeType>99</employeeType>

</employee>

<employee>

<employeeNumber>22</employeeNumber>

<employeeType>99</employeeType>

</employee>

<employee>

<employeeNumber>33</employeeNumber>

<employeeType>99</employeeType>

</employee>

</Employees>

Using the following settings:

Recordset Structure: employee,*

and Properties:

employee.fieldSeparator ,

employee.fieldNames employeeNumber,employeeType

employee.endSeparator ;

ignoreRecordsetName true

I get the following error:

more elements in file csv structure than

field names specified!

As soon as I change the endSeparator to 'nl' (and the file to match) everything works.

Is this a bug?

[Former Member · Accepted solution]

Hi Werner,

No it is not a bug.

Give the parameter <b><i>fieldSeparator</i></b> for root element i.e. Employees also and check your scenario again.

Thanks & regards,

Varun Joshi

[Former Member]

Hi Werner

Try using '0x3b' instead of ;

cheers

Sameer