How to extract data from a csv file in nodejs

Question

var fs = require('fs');
var csv = require('csv');

csv()
 .from.stream(fs.createReadStream('nodetest.csv'))
 .to.array(function(data, count) {
    var lastLine = data.slice(-1)[0];
    var needed = lastLine.slice(-1)[0];
    console.log(needed);
  });

I'm trying to extract some data from a csv file. Lets say my csv file contains these rows

ABB|BCC|CDD|DEE eff|fgg||ghh|hii ijj|JKK|kll|LMM

and I only need to extractkll from the last line

severin.julien · Accepted Answer · 2015-09-30 17:40:55Z

3

I guess you are using this npm module : csv.

You can use a simplier code to parse your CSV. And for extracting the needed value you could do :

var fs = require('fs');
var csv = require('csv');

var parser = csv.parse({delimiter: '|'}, function(err, data){
    var lastRow = data[data.length-1];
    var wantedValue = lastRow[lastRow.length-2];
    console.log(wantedValue);
});

fs.createReadStream(__dirname+'/file.csv').pipe(parser);

Notice that this code is static, but it meet your requirement. Your CSV must stay the same. Notice that I set | as a delimiter. By default CSV use the coma delimiter (hence the name Comma Separated Values).

The documentation for the parser can be found here.

edited Sep 30, 2015 at 17:40

answered Sep 30, 2015 at 17:25

severin.julien

1,3541 gold badge15 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to extract data from a csv file in nodejs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related