0

I am using csv-parse/sync library and trying to parse a .csv file that has this structure.

="212600300516","1122133",="****5401",="000272",

I am using this configurations

const { parse } = require("csv-parse/sync");

    const records = parse(text, {
      delimiter: ",",
      columns: true,
      quote: true,
      skip_empty_lines: true,
    });

But I am getting this error:

CsvError: Invalid Opening Quote: a quote is found inside a field at line 2

I think the problem is with the = equal signs and I am guessing it has something to do with the formatting of the cell. What is the best way to handle this?

Missak Boyajian
  • 1,965
  • 7
  • 32
  • 59

0 Answers0