Skip to content

Instantly share code, notes, and snippets.

@stevemu
Created April 12, 2019 11:39
Show Gist options
  • Save stevemu/205a747b0055df07bdd05d9484de762e to your computer and use it in GitHub Desktop.
Save stevemu/205a747b0055df07bdd05d9484de762e to your computer and use it in GitHub Desktop.
// convert a csv file to form like texts
// Convert a csv like this:
// Name,Age, Bob,30, John,40,
// To text like this:
// Name: Bob Age: 30
// Name: John Age: 40
var fs = require('fs');
var parse = require('csv-parse');
var parser = parse({delimiter: ','}, function(err, data){
var result = "";
// console.log(data[1]);
var headers = data[0];
var colNums = headers.length
// console.log(colNums);
// var count = 0;
for (row = 1; row < data.length; row++) {
// console.log("new applicant");
result += "\n\n\n\n";
// console.log("row" + row);
var rowData = data[row];
for (col = 0; col < colNums; col++) {
var currentHeader = headers[col];
var currentData = rowData[col];
var whole = currentHeader + ": " + currentData + "\n";
result += whole;
}
result += "\n\n";
}
console.log(result);
var stream = fs.createWriteStream("b.txt");
stream.once('open', function (fd) {
stream.write(result);
})
// fs.writeFile(__dirname + "r.txt", result, function (err) {
// if (err) {
// console.log("error");
// }
// console.log("file saved");
// })
});
fs.createReadStream(__dirname+'/source.csv').pipe(parser);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment