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

Question

I have this error when I try to parse kepler_data.csv using csv-parse using promises following Adam and Andre Negoi NodeJS course. Here is the code:

function loadPlanetsData() {
    return new Promise((resolve, reject) => {
        fs.createReadStream(
            path.join(__dirname, "..", "..", "data", "kepler_data.csv")
        )
            .pipe(
                parse({
                    comment: "#",
                    columns: true,
                })
            )
            .on("data", (data) => {
                if (isHabitalePlanet(data)) {
                    habitablePlanets.push(data);
                }
            })
            .on("error", (err) => {
                console.log(err);
                reject(err);
            })
            .on("end", () => {
                console.log(
                    `${habitablePlanets.length} habitable planets found!`
                );
                console.log("Done reading!!");
                resolve();
            });
    });
}

I tried to indicate relax-quotes but it doesn't work. How can i fix this?

Answer 1

parse({
  comment: "#",
  columns: true,
  relax_quotes: true,
  escape: "\\",
  quote: "'",
  delimiter: ",",
  ltrim: true,
  rtrim: true,
  record_delimiter: "\n",
  skip_empty_lines: true,
  relax_column_count: true
})