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
})