1.1.0 • Published 9 years ago

detect-csv v1.1.0

Weekly downloads
3,816
License
MIT
Repository
github
Last release
9 years ago

detect-csv

WindowsMac/Linux
Windows Build statusBuild 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.