Comma Separated Values¶
CSV files are a big part of my work life.
"They aid with moving information from one application to another. Tabular spreadsheet data from one program is converted into a CSV file, which is then used to import the information into another program." 1
-
Learning to read files with Node.js - https://nodejs.dev/en/learn/reading-files-with-nodejs/
-
Converting CSV file read data to an array - csvToArray (csv.js line 18)
Example usage¶
// Set CSV file name
const csvFileName = "test";
let csvArray;
try {
// Read CSV file
console.log(`Reading ${csvFileName}.csv`);
const csvData = fs.readFileSync(`./${csvFileName}.csv`, "utf-8");
// Covert to Array
csvArray = CSVToArray(csvData, ",", true);
console.log(`Converting ${csvFileName}.csv to an array:`);
console.log(csvArray);
} catch (error) {
console.log(`${error.message} (check csvFilename - line 6)`);
}
Example output¶
Reading test.csv
Converting test.csv to an array:
[ [ 'Stuff', 'Different stuff' ], [ 'test', 'test' ] ]