...
Code Block | ||
---|---|---|
| ||
// require the filesystem module 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!'); |
...