3 ms·

Regarding quoting support, check out https://github.com/dbro/csvquote https://github.com/dbro/csvquote

• acveilleux 11y ago
  Not sufficient, but close. It substitutes the quoted character for another one.
  • dbro 11y ago
    Hi- I'm curious to know what your use case is. Can you explain why substitution is not sufficient?
    • acveilleux 11y ago
      (1) I filter on column content using regex and dealing with a sub character adds complexity. (2) Many of my columns are free-form text containing commas, carriage returns, new lines, tab, vertical tabs and file separator (0x1c). Occasionally, text is in UCS-2/UTF-16 or uses UTF-8 and foreign characters (a non-trivial quantity of the text I process is in French for example.) (If you read between the lines here, some columns can contain MLLP-encoded HL7 messages, others contain free-form text and I'm in the medical field.)