Handling Oracle non-standard CSV exports

[cesar_bolanos]

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

[alchemiz]

Here’s a better version, the first version might fail for large csv files, this version replaces the left and right double quote characters per row

Handling Oracle non-standard CSV exports_2020_06_06.slp (5.1 KB)
non-double-quotes.txt (109 Bytes)