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