Write array to a CSV in nodejs

Question

I'm trying to write an array to a CSV using the fs module in node. Every time do so, it creates new columns because of the commas in the array. How can I go about doing this without creating new columns - the array should be contained within the column. My code below.

const fs = require('fs');
const writeStream = fs.createWriteStream('data.csv');
writeStream.write(`brands \n`);
writeStream.write(`${brands}\n`);

The array is just a list of strings: var brands = ["h2O, "glycerin", "cetyl", "ethylhexanoate"]

GrafiCode · Accepted Answer · 2019-07-01 16:12:38Z

5

[edit after OP's clarification]

You can use Array.join() to join single elements wrapping them in double-quotes and separating them with commas:

const fs = require('fs');

const brands = ["h2O", "glycerin", "cetyl", "ethylhexanoate"]

const writeStream = fs.createWriteStream('data.csv');


writeStream.write(`brands \n`);

writeStream.write('[ "' + brands.join('","') + '" ]\n');

edited Jul 1, 2019 at 16:12

answered Jul 1, 2019 at 15:54

GrafiCode

3,3653 gold badges31 silver badges33 bronze badges

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

4 Comments

Viper Over a year ago

Thanks, but I want to put all the items in an array format in the same row. So for example: the brands row would have "["h2O, "glycerin", "cetyl", "ethylhexanoate"]"

GrafiCode Over a year ago

@Viper You need the square brackets and double-quotes too?

Viper Over a year ago

Yes, i do need this

GrafiCode Over a year ago

@Viper Edited my answer according to your clarification. Does it help?

Collectives™ on Stack Overflow

Write array to a CSV in nodejs

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related