Flatfiel with empty line separator

[Former Member]

Hi,

ich have a faltfile like this:

dataA1;datab1;dataC1

dataA2;dataB2;dataC2

dataA3;dataB3;dataC3

the empty line is full of blank characters. what do i use as filed separator? i tried different thinks i found in the forum:

Row.fieldSeparator 'nl'

Row.fieldSeparator 'nl''nl'

Row.fieldSeparator '\n''\n'

Row.fieldSeparator '0x0D''0x0A'

but nothings works. the result in xml looks always this way:

<Row>

<fieldA>dataA1</fieldA>

<fieldB>dataB1</fieldB>

<fieldC>dataC1</fieldC>

</Row>

<Row>

<fieldA />

</Row>

<Row>

<fieldA>dataA2</fieldA>

<fieldB>dataB2</fieldB>

<fieldC>dataC2</fieldC>

</Row>

<Row>

<fieldA />

</Row>

<Row>

<fieldA>dataA3</fieldA>

<fieldB>dataB3</fieldB>

<fieldC>dataC3</fieldC>

</Row>

<Row>

<fieldA />

</Row>

anyone has a tip?

Greets J.

[Former Member]

Hi,

From your flat file the fieldSeparator should be semicolon (;).

You endSeparator should be next line (nl).

You can also add Row.fieldcontentFormatting = trim (this is by default) and Row.fieldcontentFormatting = nothing if you wnt to sustain white spaces after each row in input file.

Pls write you content conversion you have used for more clarity.

It is not clear what output is desired by you. accordingly we can help.

Regards,

satish

[Former Member]

Hi,

i just have the following conversions:

Row.fieldNames = DataA,...

Row.fieldSeparator = ;

Row.endSeparator = 'nl' (i tried a lot of other thinks)

Regards

J.

Message was edited by: Jörg Pieper