/Javascript/Node.js/How to read a csv file in nodejs

How to read a csv file in nodejs

Create csv file nodejs

const csv = require('csv-parser');
const fs = require('fs');

fs.createReadStream('data.csv')
  .pipe(csv())
  .on('data', (row) => {
    console.log(row);
  })
  .on('end', () => {
    console.log('CSV file successfully processed');
  });

Source: stackabuse.com

How to read a csv file in nodejs

$ npm i -s csv-parse

Source: stackabuse.com

Read and update csv file in nodejs

const fs = require('fs')
const csv = require('csv-parser')
const randomWords = require('random-words')
const users = [];
function generateUsername(firstname, surname) {
    return `${firstname[0]}-${surname}`.toLowerCase();
}
fs.createReadStream('input.csv')
  .pipe(csv())
  .on('data', function (row) {
    const username = generateUsername(row.Firstname, row.Surname);
    const password = randomWords(3).join("-");
    
    const user = {
        username,
        firstname: row.Firstname,
        surname: row.Surname,
        roles: row.Roles,
        password
    }
    users.push(user)
  })
  .on('end', function () {
      console.table(users)
      // TODO: SAVE users data to another file
    })

Source: heynode.com

Similar codes

0 vote298 views1 answer
Node js timestamp format
Javascript Node.js
0 vote328 views1 answer
Upload different files in different folders using Multer in NodeJs
Javascript Node.js
0 vote296 views1 answer
Nohup run nodejs
Javascript Node.js
0 vote305 views1 answer
Passing variable in table row delete button node js express
Javascript Node.js
0 vote310 views1 answer
Create file object node js
Javascript Node.js
0 vote326 views1 answer
Node express table view
Javascript Node.js
62 votes414 views6 answers
Update nodejs ubuntu
Javascript Node.js
10 votes300 views2 answers
Readline node js
Javascript Node.js
75 votes409 views3 answers
Nodejs reverse string
Javascript Node.js
0 vote308 views2 answers
How to proxy enable in server nodejs
Javascript Node.js