Skip to Content
0
Former Member
Feb 16, 2011 at 12:35 AM

How to handle newline within quotes in csv

166 Views

Hello experts,

I have an issue with reading a csv file which contains newline as a part of one of the fields (within double quotes).

I'm using the file content conversion in sender file adapter with the following

NameA.fieldNames = field1, field2, field3, field4

NameA.fieldSeparator = ,

NameA.processFieldNames = fromConfiguration

NameA.enclosureSign = "

NameA.enclosureSignEscape = ""

NameA.endSeparator = 'nl'

This doesn't work. The sender channel treats the newline within double quotes as a new record and is not reading the file correctly.

I though the NameA.enclosureSign and NameA.enclosureSignEscape parameters would do the trick and ignore text that's between the double quotes?

An I missing some Content conversion cofiguration here? Some parameter that I need to set?

Please help resolve this.

Thanks

Karthik