CODEWITHSUNDEEP
javascriptcsvparsingmultiple-columns
Tahor Sui Juris
Tahor Sui Juris

Reputation: 131

Get First Column of CSV file javascript

Have tried PapaParse without success, how would one get the first column value of a CSV file?

const csv = require('csv-parser');
const fs = require('fs');


(async () => {
    try {

        fs.createReadStream('test.csv')
            .pipe(csv())
            .on('data', (row) => {
                console.log(row);
            })
            .on('end', () => {
                console.log('CSV file successfully processed');

            });

    } catch (err) {
        console.log(error(err));
        await browser.close();
        console.log(error("Browser Closed"));
    }
})();

Upvotes: 1

Views: 2247

Answers (1)

Tahor Sui Juris
Tahor Sui Juris

Reputation: 131

For anyone in the future, set a function then set as a const to your CSV list of URLs, the number [1] represents the column.

function readURLFile(path) {
    return fs.readFileSync(path, 'utf-8')
        .split('\n')
        .map((elt) => {
            const url = elt.split(',')[1].replace('\r', '');
            return `http://${url.toLowerCase()}`;
        });
}

Upvotes: 2

Related Questions