FileAdapter to read "|" (pipe) seperated file

[Former Member]

Hi all,

when using "file content conversion" in the sender file adapter and having a "," or ";" as a seperator everything is fine.

But I now have a "|" (pipe symbol) as the seperator character. The adapter does not seem to recognize this "|" as a single character and keeps the original line unchanged, that I don't get my XML I wanted

I tried various other settings like the hex-representation, '|', "|" or | without qoutes, but not success so far.

So if someone has come across this already and solved it ... please post.

Thx

Uwe

[Former Member]

Uwe,

Check if your parameters are like below:-

line.fieldSeparator |

line.fieldNames <field1>,<field2>,<field3>

line.processFieldNames fromConfiguration

line.endSeparator 'nl'

Bipin

[Former Member]

Hi all,

these settings are working :

line.fieldSeparator |

line.fieldNames <field1>,<field2>,<field3>

line.processFieldNames fromConfiguration

line.endSeparator 'nl'

I have seperated the fieldNames as well with |

thanks a lot to all

Uwe

[Former Member]

Hi,

Just give | as field Separator.

No enclosure symbols.This is the right configuration.

Kindly post ur XML structure and content conversion parameters u have used.

Regards,

Sudharshan

Message was edited by:

Sudharshan Aravamudan

[Former Member]

Hi,

has you checked the enconding of the file?

bye

[Former Member]

Hi Uwe,

Could you please post the file content conversion parameters that you have used/maintained?

Thanks.