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 trimable are ECMAScript whitespaces and line terminator set.

• Basic Latin
  • 0x0020 Space
  • 0x0009 CHARACTER TABULATION (HT)
  • 0x000a LINE FEED (LF)
  • 0x000d CARRIAGE RETURN (CR)
  • 0x000c FORM FEED (FF)
  • 0x000b LINE TABULATION (VT)
• Latin-1 Supplement
  • 0x00a0 NO-BREAK SPACE (NBSP)
• Ogham
  • 0x1680 OGHAM SPACE MARK
• General Punctuation
  • 0x2000 EN QUAD
  • 0x2001 EM QUAD
  • 0x2002 EN SPACE
  • 0x2003 EM SPACE
  • 0x2004 THREE-PER-EM SPACE
  • 0x2005 FOUR-PER-EM SPACE
  • 0x2006 SIX-PER-EM SPACE
  • 0x2007 FIGURE SPACE
  • 0x2008 PUNCTUATION SPACE
  • 0x2009 THIN SPACE
  • 0x200a HAIR SPACE
  • 0x2028 LINE SEPARATOR
  • 0x2029 PARAGRAPH SEPARATOR
  • 0x202f NARROW NO-BREAK SPACE (NNBSP)
  • 0x205f MEDIUM MATHEMATICAL SPACE (MMSP)
  • 0x3000 IDEOGRAPHIC SPACE
  • 0xfeff ZERO WIDTH NO-BREAK SPACE (BOM)

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"],
]);