_ _ _ _____ _______ __
| \ | | | | / ____|/ ____\ \ / /
| \| | ___ __| | ___ | | | (___ \ \ / /
| . ` |/ _ \ / _` |/ _ \| | \___ \ \ \/ /
| |\ | (_) | (_| | __/| |____ ____) | \ /
|_| \_|\___/ \__,_|\___| \_____|_____/ \/ New BSD License
This project provides CSV parsing and has been tested and used on large input files. It provides every option you would expect from an advanced CSV parser and stringifier.
The full documentation of the CSV parser is available here.
There is at the moment an important re-design of this module. The project is now splited into 4 packages:
csv-generate, a flexible generator of CSV string and Javascript objects.csv-parse, a parser converting CSV text into arrays or objects.stream-transform, a transformation framework.csv-stringify, a stringifier converting records into a CSV text.
Each modules are fully be compatible with the stream 2 and 3 specifications. Also, a simple callback-based API is provided. Those modules are already released and usable separately. They will soon be available as part of this module. We are in the process of dispatching the full test cases into their appropriate module.
Installation command is npm install csv.
// node samples/string.js
csv()
.from.string(
'#Welcome\n"1","2","3","4"\n"a","b","c","d"',
{comment: '#'} )
.to.array( function(data){
console.log(data)
} );
// [ [ '1', '2', '3', '4' ], [ 'a', 'b', 'c', 'd' ] ]// node samples/sample.js
var fs = require('fs');
var csv = require('csv');
// opts is optional
var opts = ;
csv()
.from.path(__dirname+'/sample.in', { delimiter: ',', escape: '"' })
.to.stream(fs.createWriteStream(__dirname+'/sample.out'))
.transform( function(row){
row.unshift(row.pop());
return row;
})
.on('record', function(row,index){
console.log('#'+index+' '+JSON.stringify(row));
})
.on('close', function(count){
// when writing to a file, use the 'close' event
// the 'end' event may fire before the file has been written
console.log('Number of lines: '+count);
})
.on('error', function(error){
console.log(error.message);
});
// Output:
// #0 ["2000-01-01","20322051544","1979.0","8.8017226E7","ABC","45"]
// #1 ["2050-11-27","28392898392","1974.0","8.8392926E7","DEF","23"]
// Number of lines: 2This README covers the current version 0.2.x of the node csv parser. The documentation for the previous version (0.1.0) is
available here. The documentation
for the incoming 0.3.x version is not yet released.
The functions 'from*' and 'to*' are now rewritten as 'from.' and 'to.'. The 'data' event is now the 'record' event. The 'data' now receives a stringified version of the 'record' event.
Tests are executed with mocha. To install it, simple run npm install, it will install
mocha and its dependencies in your project "node_modules" directory.
To run the tests:
npm testThe tests run against the CoffeeScript source files.
To generate the JavaScript files:
make buildThe test suite is run online with Travis against Node.js version 0.6, 0.7, 0.8 and 0.9.
-
David Worms: <https://github.com/wdavidw> -
Will White: <https://github.com/willwhite> -
Justin Latimer: <https://github.com/justinlatimer> -
jonseymour: <https://github.com/jonseymour> -
pascalopitz: <https://github.com/pascalopitz> -
Josh Pschorr: <https://github.com/jpschorr> - Elad Ben-Israel: https://github.com/eladb
- Philippe Plantier: https://github.com/phipla
- Tim Oxley: https://github.com/timoxley
- Damon Oehlman: https://github.com/DamonOehlman
- Alexandru Topliceanu: https://github.com/topliceanu
- Visup: https://github.com/visup
- Edmund von der Burg: https://github.com/evdb
- Douglas Christopher Wilson: https://github.com/dougwilson
- Chris Khoo: https://github.com/khoomeister
- Joeasaurus: https://github.com/Joeasaurus
- Pavel Kolesnikov "ya-csv": http://github.com/koles/ya-csv
- Chris Williams "node-csv": http://github.com/voodootikigod/node-csv