How to read from local .csv file in javascript to fill an array of strings?

Question

I have a CSV file with 100 names per line. I want to create an array containing each name. Currently, my CSV file looks like this:

Names
Bob
Joe
Tim
Allan

and I want to fill the array as follows:

const csv = require('csv-parser');
const fs = require('fs');    
const names= [];
fs.createReadStream('./Names.csv')
  .pipe(csv())
  .on('data', (data) => names.push(data.Names))
  .on('error', (error) => loggingService.getDefaultLogger().error(error))
  .on('end', () => loggingService.getDefaultLogger().info("Array of Names:" + names));

Using a logging service I've created I see all names from the CSV. When I do console.log(names) I get an empty array. Might anyone know why this is? More specifically is there a better way to read from a CSV file so that I can fill an array of strings with the contents of that file, 1 array entry as a string per line?

I wonder where your console.log() statement is? If after presented code - yes names would be empty because reading is asynchronous and you getting to console faster than finish reading from file — bensiu
– bensiu, Commented Sep 30, 2020 at 22:44
I'm not familiar with the CSV library, but in the following snippet, where does devices come from ? (data) => devices.push(data.Names) — Hassan
– Hassan, Commented Sep 30, 2020 at 22:45
@bensiu It is after the code snippet. If I want to iterate through the array of names and do something with them, how would I overcome the asynchronous reading? Ideally I want to fill the array, then do a forEach element in the array, create a new object. Before that forEach the I'm not sure the names array would be full. — ENV
– ENV, Commented Sep 30, 2020 at 22:56
@Hassan that was a typo. it should be: names.push(data.Names). — ENV
– ENV, Commented Sep 30, 2020 at 22:57

Berk Ege · Accepted Answer · 2020-09-30 23:02:52Z

1

May work but not sure.

Edit: Yup working like a charm.

const fs = require('fs');

let Names = [];

fs.readFile('./names.csv', 'utf8', (err, dat) => {
  if(err)
    console.error("Error while opening file");

  Names = String(dat).split('\n');
});

edited Sep 30, 2020 at 23:02

answered Sep 30, 2020 at 22:45

Berk Ege

866 bronze badges

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

Collectives™ on Stack Overflow

How to read from local .csv file in javascript to fill an array of strings?

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