Parse a CSV table from a variable in node.js

Question

I have a node application which can end up with a CSV formatted table in a variable.

I'd like to parse it into a JSON style format.

All of the modules I've looked at seem to only take input from files (unless I'm misunderstanding)

Are there any modules out there which do what I'd like or would I be better off just rolling my own solution?

Thanks!

JP Richardson · Accepted Answer · 2012-10-15 17:41:35Z

3

As an alternative, you could use string.js. It works on Node.js and client side in the browser. Disclaimer: I'm the author.

Example:

var S = require('string');
S(myCsvData).lines().forEach(function(line){
  var fields = S(line).parseCSV();
});

answered Oct 15, 2012 at 16:53

JP Richardson

39.6k36 gold badges123 silver badges152 bronze badges

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

1 Comment

I found that this is a much simpler and faster approach. Thanks!

Abdullah Jibaly · Accepted Answer · 2012-10-15 16:26:15Z

2

This example from NodeCSV seems to be parsing from a variable:

var csv = require('csv');
csv()
   .from( '"1","2","3","4"\n"a","b","c","d"' )
   .to( console.log )

In general, Node.js lets you treat both files and strings as streams. It's usually pretty trivial to go from one to the other.

answered Oct 15, 2012 at 16:12

Abdullah Jibaly

55.2k45 gold badges129 silver badges201 bronze badges