/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

2 votes125 views1 answer
Node file change event listener
Javascript Node.js
-1 vote118 views1 answer
Node how to set environment variable
Javascript Node.js
1 vote129 views1 answer
Node red admin password setting
Javascript Node.js
0 vote117 views1 answer
Get image center pixels nodejs
Javascript Node.js
0 vote124 views1 answer
How to redirect 404 errors to a page in node js server?
Javascript Node.js
0 vote127 views1 answer
How to include build script in node js
Javascript Node.js
0 vote139 views1 answer
Create directory when writing to file in nodejs
Javascript Node.js
17 votes158 views3 answers
Read json file node js
Javascript Node.js
75 votes163 views3 answers
Nodejs reverse string
Javascript Node.js
6 votes152 views2 answers
How to install mongodb in node js
Javascript Node.js