csvjsified
v1.0.0
Published
Parse a CSV file into a JS object fo further processing
Downloads
1
Readme
csvjsified
I've been working with Kibana quite a lot recently, and it's ability to export search results to CSV is useful for further analysis in my tool of choice (node right now).
I've extracted this common functionality (parse CSV) as I found myself re-writing it every time I need to do some CSV analysis. I couldn't find an existing 'simple enough' library (in npm
) to do the job...
Example usage
Once you've installed the module via npm install csvjsified
, to use it simply
const { fromFilePath } = require('csvjsified')
fromFilePath('/path/to/file.csv')
.then(console.log, console.error)
/**
For a CSV file with content like:
"header1","header2","header3"
"a1","b1","c1"
"a2","b2","c2"
fromFilePath returns an array that will print as:
[ { header1: 'a1', header2: 'b1', header3: 'c1' },
{ header1: 'a2', header2: 'b2', header3: 'c2' } ]
**/
By default, a quote "
is used as a field delimiter. You can pass a custom delimiter in the [optional] parameters argument:
const { fromFilePath } = require('csvjsified')
fromFilePath('/path/to/file.csv', {delimiter: '|'}) // use pipe character as field delimiter