Handling Oracle non-standard CSV exports
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”,"qu...
Forum Discussion
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.
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)
