Forum Discussion

andre_mangatal's avatar
andre_mangatal
New Contributor
7 years ago

HELP PLEASE - CSV Parser Advice Reading Delimiter In Data Fields

Good day SnapLogic Community I would greatly appreciate your help with the following. We have a cloud pipeline reading data from a REST service and returns the data in a comma delimited string. It ...
andre_mangatal's avatar
andre_mangatal
New Contributor
7 years ago

Hi Tim

Thanks for your reply. Attached is a row of data that is throwing the error. There is a custom XML field called “CustomXML”. I attached the file because it wasn’t displaying properly here.

Sample_Data.txt (1.4 KB)

tstack's avatar
tstack
Former Employee
7 years ago

It looks like it’s not quoted, that’s too bad. If the <CustomXML> tag is pretty unique, you could try to add quoting by doing some string replacement using a mapper snap, like so:

$content.replace(/(\n<CustomXML>)/g, '"$1').replace(/(<\/CustomXML>)/g, '$1"')

This expression adds a double quote before the start tag and then another one after the end tag.