/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 vote136 views1 answer
Node spawn stdout stderr
Javascript Node.js
4 votes145 views2 answers
How to use static file node js
Javascript Node.js
16 votes149 views3 answers
Node mon install
Javascript Node.js
19 votes157 views3 answers
Node read file sync
Javascript Node.js
1 vote148 views1 answer
Introdução ao nodeJs
Javascript Node.js
0 vote113 views1 answer
Configuration file must specify a supported nodejs10 version that is compatible with the runtime specified in the deployment.
Javascript Node.js
0 vote150 views2 answers
How to run node js with proxy
Javascript Node.js
-2 votes160 views1 answer
Formidable form node js
Javascript Node.js
1 vote153 views1 answer
Create unique transaction ids nodejs
Javascript Node.js
0 vote151 views1 answer
Shopify functions nodejs
Javascript Node.js