A CSV parser for node.js that will parse provided text data or stream parse a file. This allows you to process large files efficiently and using the raw power of node.js's event system.
var csv = require('node-csv');
Imports the CSV parser into your code for use under the variable named 'csv'. Use this to access the functions within the CSV parser.
lines = 0;
csv.each('file.csv').on('data', function(data) {
lines++;
}).on('end', function() {
console.log(lines + ' lines parsed');
})
Opens and stream parses a CSV file provided by the first argument value. The second argument can be an options object with the following attributes:
- headers: true or false values expected, if true the first row of the provided file will be used as headers and not emitted as data. Furthermore all other rows within the CSV will be converted from array objects to new objects with attributes identified in the headers row.
- strDelimiter: String delimiter that is used to separate data values within the file. Default is ",", but can be any value.
- readAmount: Number of bytes to read on each cycle. The smaller the value, the faster the 'data' event is emitted, but it will be more processor and memory intensive. Default is recommended.
csv.parse("a,b,c,e,f\nk,l,m,s,d", function(data) { console.log(data); })
Parses a string CSV value and emits 'data' events. Second argument must either be a callback function that will be passed the parsed rows OR an options object with the same attributes as above. If the options object is provided, the third argument must be the callback function.