file receiver nl

[Former Member]

hello

I have a JDBC to File scenario with content conversion csv file.

in one of the field of the file I have a String. for some reason I might be getting a nl from the DB (or something else that cuase my file to go to the next line). I am using fieldSeparator = , .

does any one know how can I avoid this from happening with out going to the next line between the ,?

I though maybe to change something in the DB?

Thanks

Kfir

[former_member182004 · Accepted solution]

Hey!

You can try to use a trim function in the message mapping before the target document gets into the receiver adapter (maybe this cant take off those characters)

Regards,

Juan.

[baskar_gopalakrishnan2 · Accepted solution]

> You can try to use a trim function in the message mapping before the target document gets into the receiver adapter (maybe this cant take off those characters)

trim function will trim only if empty space characters available. Not next line ...

[Former Member · Accepted solution]

Use endSeperator function.