Option `skip_empty_lines`

The skip_empty_lines skips any line which is empty.

Type: boolean
Optional
Default: false
Since: 0.0.5
Related: skip_records_with_error, trim — see Available Options

Example

The option.skip_empty_line.js example activates the option by setting its value to true:

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

const records = parse(
  dedent`
    "a","b","c"

    "d","e","f"
  `,
  {
    skip_empty_lines: true,
  },
);

assert.deepStrictEqual(records, [
  ["a", "b", "c"],
  ["d", "e", "f"],
]);

./packages/csv-parse/samples/option.skip_empty_lines.js

Whitespace characters

The line must be completely empty, without any characters including spaces and tabs. If you happens to have such characters, you can associate the skip_empty_lines option with the trim option:

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

const data = `
"a","b","c"
\t
"d","e","f"
`;
const records = parse(data, {
  skip_empty_lines: true,
  trim: true,
});

assert.deepStrictEqual(records, [
  ["a", "b", "c"],
  ["d", "e", "f"],
]);

./packages/csv-parse/samples/option.skip_empty_lines.js

Another possibility includes using a combination of skip_records_with_empty_values and relax_column_count.

Option skip_empty_lines

Example

Whitespace characters

Option `skip_empty_lines`