โ11-20-2018 06:39 AM
We have worked on several projects where Oracle DBAs create direct table extracts using standard Oracle tools. Those tools do not generated properly escaped CSV files. As such, lines like
โ123โ,"quote",โtestโ
โ345โ,โMc"Donaldsโ,โtest2โ
Cause Snaplogicโs CSV parser to reject those lines
Does anyone have any recommendations on how to deal with this type of file?
Thanks
PS We even have a case in which a database column has JSON text, which compounds the non-escaped values even further
โ06-03-2020 04:24 PM
Hi Cesar,
we are facing similar issue inclusing additional non english characters parsing. Do you have any solution found for this. TIA.
โ06-03-2020 06:17 PM
Hi, I did encounter this unlikely double quotes before so what I did was do a cleanup of those characters using a mapper with binary inputโฆ first replace all " with " to escape that character then replace the double-quotes with the regular one ๐
โ06-03-2020 06:32 PM
Hi,
Thanks for reply, will this resolve issue with only double quotes or also non english characters are mapped in transformation. (if possible can you include the formula used in transformation.)
can you please tell the reason for including document to binary before csv parser.
Thank you in advance.
โ06-05-2020 09:49 AM
CSV parser input needs to be a binary
.replace(/"/g,โ\"โ). โ replace all " to "
.replace(/โ/g,โ"โ) โ replace all โ to "
.replace(/โ/g,โ"โ) โ replace all โ to "