[FEATURE] Parsing row issue

[LiYiuShing]

Parsing or Formatting?

• [] Formatting
• Parsing

Hi, I'm trying to load my CSV into an array. However, it failed cause of Error: Parse Error: expected: '\|' OR new line got: 'S'. at 'SADDD" 00:. I knew the error is caused by ", but I don't know how to set the option to escape that.

This is one of my failed row:
"ABC"|"123"|"EFG- "SADDD" 00:10L"|" "|""|"Testing"|"testing2"|"testing3"|"testing4"

This is my csv option:

const CSV_OPTIONS = {
    objectMode: true,
    delimiter: "|",
    rowDelimiter: "\r\n",
    headers: true,
    strictColumnHandling: true,
    discardUnmappedColumns: true,
    renameHeaders: false,
    ignoreEmpty: true,
};

[MahbbRah]

I've hard also that issue as well as for data with commas. couldn't just parse it. so thus had to ditch the library and instead use papaParse stream now. it could parse everything and whatever you have on CSV.