/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 vote221 views1 answer
Node js login and registration
Javascript Node.js
0 vote185 views1 answer
Node js hello word
Javascript Node.js
54 votes364 views6 answers
How to update node js version
Javascript Node.js
27 votes206 views5 answers
Node get all files in folder
Javascript Node.js
0 vote179 views1 answer
How to get user info from google oauth node js
Javascript Node.js
10 votes192 views2 answers
Readline node js
Javascript Node.js
0 vote187 views1 answer
Passing variable in table row delete button node js express
Javascript Node.js
0 vote194 views2 answers
Axios node js
Javascript Node.js
2 votes179 views2 answers
Send multipart form data axios with node js
Javascript Node.js
0 vote186 views1 answer
Nodejs read file sent in the request without saving to file system
Javascript Node.js