Forum Discussion

cesar_bolanos's avatar
cesar_bolanos
New Contributor
7 years ago

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...
Ravi's avatar
Ravi
New Contributor
6 years ago

Hi Cesar,
we are facing similar issue inclusing additional non english characters parsing. Do you have any solution found for this. TIA.

  • alchemiz's avatar
    alchemiz
    Contributor III
    6 years ago

    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 😆

    • Ravi's avatar
      Ravi
      New Contributor
      6 years ago

      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.

      • alchemiz's avatar
        alchemiz
        Contributor III
        6 years ago

        CSV parser input needs to be a binary

        .replace(/"/g,‘\"’). ← replace all " to "
        .replace(/“/g,‘"’) ← replace all “ to "
        .replace(/”/g,‘"’) ← replace all ” to "