/Javascript/Node.js/Read and update csv file in nodejs

Read and update csv file in nodejs

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

6 votes254 views1 answer
Node run parameters
Javascript Node.js
1 vote277 views1 answer
Node js sqlite3
Javascript Node.js
0 vote279 views1 answer
Node close rabbitmq connection
Javascript Node.js
11 votes273 views4 answers
Get file extension nodejs
Javascript Node.js
0 vote275 views1 answer
Tskill nodejs port
Javascript Node.js
3 votes305 views1 answer
Using dto in node js
Javascript Node.js
0 vote295 views1 answer
How to get file tree of specific folder in node js
Javascript Node.js
3 votes276 views2 answers
Nodejs path
Javascript Node.js
19 votes274 views4 answers
Read directory in node js
Javascript Node.js
21 votes300 views2 answers
Nodejs check if file is running on server or client
Javascript Node.js