Created
April 12, 2019 11:39
-
-
Save stevemu/205a747b0055df07bdd05d9484de762e to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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