Option trim

The trim option ignore whitespace characters immediately around the delimiter. Defaults to false. It does not remove whitespace present inside the quotes of a field.

• Type: boolean
• Optional
• Default: false
• Since: early days
• Related: ltrim, rtrim — see Available Options

The characters interpreted as whitespaces are identical to the \s meta character in regular expressions:

• Horizontal tab, String.fromCharCode(9)
• NL line feed, new line, String.fromCharCode(10)
• NP Form feed, new page, String.fromCharCode(12)
• Carriage return, String.fromCharCode(13)
• Space, String.fromCharCode(32)

Example

This example insert spaces around fields at multiple locations.

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

const records = parse("a ,1\nb, 2\n c,3", {
  trim: true,
});
assert.deepStrictEqual(records, [
  ["a", "1"],
  ["b", "2"],
  ["c", "3"],
]);