Option skip_records_with_empty_values

The skip_records_with_empty_values option don't generate records for lines containing empty values (column matching /\s*/), empty Buffer or equals to null and undefined if their value was casted, defaults to false.

• Type: boolean
• Optional
• Default: false
• Since: 1.1.8
• Related: skip_empty_lines, skip_records_with_error — see Available Options

Usage

In this example, the second line contains empty fields composed of zero characters, spaces and tabs:

import assert from "node:assert";
import { parse } from "csv-parse";

const data = `
a,b,c
, ,\t
d,e,f
`;
parse(
  data,
  {
    skip_records_with_empty_values: true,
  },
  (err, records) => {
    assert.deepStrictEqual(records, [
      ["a", "b", "c"],
      ["d", "e", "f"],
    ]);
  },
);