21 lines
752 B
JavaScript
21 lines
752 B
JavaScript
const fs = require('fs')
|
|
const read1252file = require('./read1252file');
|
|
//read the entire file as a string
|
|
let data = read1252file.read('./210211_TicketSort_2021.csv');
|
|
//console.log('data: '+data);
|
|
//split data into an array of rows(records)
|
|
data = data.split(/\r?\n/);
|
|
//traverse the data array and split the records into individual columns(fields)
|
|
for (let i in data) {
|
|
console.log('i:'+i);
|
|
data[i] = data[i].split(';');
|
|
console.log('price level: '+data[i][4]);
|
|
console.log('price level id: '+data[i][5]);
|
|
//console.log('data[i]:'+data[i]);
|
|
}
|
|
const dataLength=data.length;
|
|
console.log('dataLength: '+dataLength);
|
|
const dataLast=dataLength - 1;
|
|
console.log('dataLast: '+dataLast);
|
|
console.log('data[dataLast]: '+data[dataLast]);
|