csv-string
PARSE and STRINGIFY for CSV strings. It's like JSON object but for CSV. It can also work row by row. And, if can parse strings, it can be use to parse files or streams too.
Last updated 5 months ago by touv .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install csv-string 
SYNC missed versions from official npm registry.

Javascript CSV Strings

Build Status

Parse and Stringify for CSV strings.

  • API similar to the JSON parser (CSV.parse and CSV.stringify).
  • Can also work row by row.
  • Can also be used to parse strings from readable streams (e.g. file streams).
  • Tolerant with the weird data
  • Written in TypeScript
import * as CSV from 'csv-string';

// with String
const arr = CSV.parse('a,b,c\na,b,c');
const str = CSV.stringify(arr);

// with Stream
const stream = CSV.createStream();
stream.on('data', rows => {
  process.stdout.write(CSV.stringify(rows, ','));
});
process.stdin.pipe(stream);

Contributors

Installation

using npm:

npm install csv-string

or yarn

yarn add csv-string

API Documentation

parse(input: string, [separator: string], [quote: string]): Object

Converts a CSV string input to array output.

const CSV = require('csv-string');
const parsedCsv = CSV.parse('a,b,c\na,b,c');
console.log(parsedCsv);

Output:

[
  ["a", "b", "c"],
  ["a", "b", "c"]
]

If separator parameter is not provided, it is automatically detected.

stringify(input: Object, [separator: string]): string

Converts object input to a CSV string.

import * as CSV from 'csv-string';

console.log(CSV.stringify(['a', 'b', 'c']));
console.log(
  CSV.stringify([
    ['c', 'd', 'e'],
    ['c', 'd', 'e']
  ])
);
console.log(CSV.stringify({ a: 'e', b: 'f', c: 'g' }));

Output:

a,b,c

c,d,e
c,d,e

e,f,g

detect(input: string): string

Detects the best separator.

import * as CSV from 'csv-string';

console.log(CSV.detect('a,b,c'));
console.log(CSV.detect('a;b;c'));
console.log(CSV.detect('a|b|c'));
console.log(CSV.detect('a\tb\tc'));

Output:

,
;
|
\t

forEach(input: string, sep: string, quo: string, callback: function)

forEach(input: string, sep: string, callback: function)

forEach(input: string, callback: function)

callback(row: array, index: number): void

Calls callback for each CSV row/line. The Array passed to callback contains the fields of the current row.

import * as CSV from 'csv-string';

const data = 'a,b,c\nd,e,f';

CSV.forEach(data, ',', function (row, index) {
  console.log('#' + index + ' : ', row);
});

Output:

#0 :  [ 'a', 'b', 'c' ]
#1 :  [ 'd', 'e', 'f' ]

read(input: string, sep: string, quo: string, callback: function): number

read(input: string, sep: string, callback: function): number

read(input: string, callback: function): number

callback(row: array): void

Calls callback when a CSV row is read. The Array passed to callback contains the fields of the row. Returns the first offset after the row.

import * as CSV from 'csv-string';

const data = 'a,b,c\nd,e,f';

const index = CSV.read(data, ',', row => {
  console.log(row);
});

console.log(data.slice(index));

Output:

[ 'a', 'b', 'c' ]
d,e,f

readAll(input: string, sep: string, quo: string, callback: function): number

readAll(input: string, sep: string, callback: function): number

readAll(input: string, callback: function): number

callback(rows: array): void

Calls callback when all CSV rows are read. The Array passed to callback contains the rows of the file. Returns the offset of the end of parsing (generaly it's the end of the input string).

import * as CSV from 'csv-string';

const data = 'a,b,c\nd,e,f';

const index = CSV.readAll(data, row => {
  console.log(row);
});

console.log('-' + data.slice(index) + '-');

Output:

[ [ 'a', 'b', 'c' ], [ 'd', 'e', 'f' ] ]
--

readChunk(input: string, sep: string, quo: string, callback: function): number

readChunk(input: string, sep: string, callback: function): number

readChunk(input: string, callback: function): number

callback(rows: array): void

Calls callback when all CSV rows are read. The last row could be ignored, because the remainder could be in another chunk. The Array passed to callback contains the rows of the file. Returns the offset of the end of parsing. If the last row is ignored, the offset will point to the beginnning of the row.

import * as CSV from 'csv-string';

const data = 'a,b,c\nd,e';

const index = CSV.readChunk(data, row => {
  console.log(row);
});

console.log('-' + data.slice(index) + '-');

Output:

[ [ 'a', 'b', 'c' ] ]
--

createStream(options: Object): WritableStream

createStream(): WritableStream

Create a writable stream for CSV chunk. Options are :

  • separator : To indicate the CSV separator. By default is auto (see the detect function)
  • quote** : To indicate the CSVquote.

Example : Read CSV file from the standard input.

const stream = CSV.createStream();

stream.on('data', row => {
  console.log(row);
});

process.stdin.resume();
process.stdin.setEncoding('utf8');
process.stdin.pipe(stream);

Contribution

  • clone
  • yarn install
  • ... do the changes, write tests
  • yarn test (ensure all tests pass)
  • yarn bench (to check the performance impact)

Related projects

Benchmark

There is a quite basic benchmark to compare this project to other related ones, using file streams as input. See ./bench for source code.

the test

yarn bench

the result

for a test file with 949,044 rows

Package Time Output/Input similarity
a-csv 6.01s ~99%
csv-stream 6.64s ~73%
csv-streamer 7.03s ~79%
csv-string 6.53s 100%
fast-csv 12.33s 99.99%
nodecsv 7.10s 100%

License

MIT/X11

Current Tags

  • 4.0.1                                ...           latest (5 months ago)

41 Versions

  • 4.0.1                                ...           5 months ago
  • 4.0.0                                ...           5 months ago
  • 3.2.0                                ...           6 months ago
  • 3.1.8                                ...           7 months ago
  • 3.1.7                                ...           10 months ago
  • 3.1.6                                ...           a year ago
  • 3.1.5                                ...           2 years ago
  • 3.1.4                                ...           2 years ago
  • 3.1.3                                ...           2 years ago
  • 3.1.2                                ...           3 years ago
  • 3.1.0                                ...           3 years ago
  • 3.0.3                                ...           3 years ago
  • 3.0.2                                ...           3 years ago
  • 3.0.1                                ...           3 years ago
  • 3.0.0                                ...           3 years ago
  • 2.3.3                                ...           3 years ago
  • 2.3.2                                ...           4 years ago
  • 2.3.1                                ...           4 years ago
  • 2.3.0                                ...           5 years ago
  • 2.2.5                                ...           6 years ago
  • 2.2.4                                ...           6 years ago
  • 2.2.3                                ...           6 years ago
  • 2.2.2                                ...           6 years ago
  • 2.2.1                                ...           6 years ago
  • 2.1.1                                ...           7 years ago
  • 2.1.0                                ...           7 years ago
  • 2.0.4                                ...           7 years ago
  • 2.0.3                                ...           7 years ago
  • 2.0.2                                ...           7 years ago
  • 2.0.1                                ...           7 years ago
  • 2.0.0                                ...           7 years ago
  • 1.2.2                                ...           7 years ago
  • 1.2.1                                ...           7 years ago
  • 1.2.0                                ...           7 years ago
  • 1.1.0                                ...           7 years ago
  • 1.0.5                                ...           7 years ago
  • 1.0.4                                ...           7 years ago
  • 1.0.3                                ...           8 years ago
  • 1.0.2                                ...           8 years ago
  • 1.0.1                                ...           8 years ago
  • 1.0.0                                ...           8 years ago
Maintainers (2)
Downloads
Today 0
This Week 87
This Month 111
Last Day 2
Last Week 6
Last Month 166
Dependencies (0)
None
Dev Dependencies (14)
Dependents (91)

Copyright 2014 - 2016 © taobao.org |