...
Install Modules
You need to install the csv-parse
and csv-stringify
module to be able to turn a CSV file into a data structure and later create a CSV file from that data structure.
...
Code Block | ||
---|---|---|
| ||
// require the filesystem modulesmodule var fs = require('fs'); // require csv modules var parse = require('csv-parse/lib/sync'); var stringify = require('csv-stringify/lib/sync'); // read the file var data = fs.readFileSync('data.csv'); // convert the data to a table var table = parse(data, { delimiter: ';' }); // create a new table var newTable = []; // loop through the data for(var i=0; i<table.length; i++) { // create a new rworow var newRow = [table[i][0], table[i][1] * 1000]; // add the row to the new table newTable.push(newRow) } // generate csv data from the new table var newData = stringify(newTable, { delimiter: ';' }); // console.log(newData); // write file fs.writeFileSync('data_new.csv', newData); console.log('Yay!'); |
Run Script
To Run the script as following to read the CSV and generate a new CSV run the script as following:
Code Block | ||
---|---|---|
| ||
node script.js |