[Best way to load CSV's without csv-parser] #JavaScript #CSV

loadCSV.js

 
const {readFile} = require("fs").promises;
const run = async () => {
    const loadCSV = async (fileName ) => {
        const contents = await readFile(fileName, 'utf8');
        const lines = contents
            .split('\n')
            .filter(Boolean)
            .map((t)=>t.trim()) // remove leading and trailing \r for non-utf8 files
            .map((line)=>{
                // this regex, allows "quoted strings", and non-quoted strings in a csv.
                const cells = line.match(/(".*?"|[^",]+)(?=\s*,|\s*$)/g)
                // Map removes the quotes from the quoted strings. 
                // I advise not to trim each cell because someone might have put white space into a cell that is quoted.
                const [ col1, col2, col3, col4 ] = cells.map(cell=>cell.replace(/^"(.+(?="$))"$/, '$1'))
                return { col1, col2, col3, col4 }
            });
        console.log(`Read ${lines.length} from ${fileName}` )
        return lines
    }
    
    const records = [
        ...await loadCSV( 'some-data.csv' ) 
    ]
 
}

run().then(()=>{console.log('done')}).catch(console.error).then(() => process.exit(0))