Skip to content

Latest commit

 

History

History
31 lines (23 loc) · 1.2 KB

readme.md

File metadata and controls

31 lines (23 loc) · 1.2 KB

detect-csv

Windows Mac/Linux
Windows Build status Build Status

Detect if a chunk in the beginning of a CSV (in the sense of character seperated values) is valid and determine the delimiter character. Install with npm install detect-csv.

Right now it only parses the first line and counts characters. So the rest of the CSV might be invalid. Also I recommend checking for json/ndjson first, since it's the more strict format.

var detect = require('detect-csv')

var csv = detect('a,b,c\n1,2,3')

console.log(csv.delimiter)
console.log(csv.newline)
// prints ',' and '\n'

var isCsv = detect('notacsv')
console.log('This is ' + (isCsv ? '' : 'not') + ' a csv') 
// prints: This is not a csv

You add the following options as a second parameter:

  • delimiters Delimiters to detect, defaults to [',', ';', '\t', '|'].
  • newlines Newline characters to detect, defaults to ['\n', '\r'].

Delimiters and newlines don't work with multiple characters, e.g. \r\n.