Reading csv file using node.js

Question

I'm trying to read a csv file using node.js. I'm getting the error "unexpected end of input". The following is the code I've used:

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


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

I've taken the code from here.

when I run the above code in command mode using "node sample.js", the following is the error:

C:\Users\learningsql\Desktop\filter>node sample.js
C:\Users\learningsql\Desktop\filter\sample.js:12
    console.log('CSV file successfully processed');


SyntaxError: Unexpected end of input
[90m    at wrapSafe (internal/modules/cjs/loader.js:1047:16)[39m
[90m    at Module._compile (internal/modules/cjs/loader.js:1097:27)[39m
[90m    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1153:10)[39m
[90m    at Module.load (internal/modules/cjs/loader.js:977:32)[39m
[90m    at Function.Module._load (internal/modules/cjs/loader.js:877:14)[39m
[90m    at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)[39m
[90m    at internal/main/run_main_module.js:18:47[39m

Any help is appreciated. Thanks.

I got it. If anyone's curious, I used this code const parse = require('csv-parse'); const fs = require('fs'); const csvData= []; fs.createReadStream(__dirname + '/filename.csv') .pipe( parse({ delimiter: ',' }) ) .on('data', function (dataRow) { csvData.push(dataRow); }) .on('end', function () { console.log(csvData); }); — learningsql
– learningsql, Commented May 12, 2020 at 9:50
This code is missing the closing brackets from the end });. — Ervin Szilagyi
– Ervin Szilagyi, Commented May 12, 2020 at 9:52

Tanya Gupta · Accepted Answer · 2020-05-12 09:52:05Z

1

Try this:

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


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

You were missing the closing parentheses and bracket

answered May 12, 2020 at 9:52

Tanya Gupta

5704 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

learningsql Over a year ago

thanks. I'm able to read the csv file and get all the columns into arrays, but I need only one specific column's elements as an array. Any suggestions?

learningsql Over a year ago

What does "addresses" mean here? Do I replace address_1 with column name of the column I want the records of? Please refer to this link to understand what I'm trying to do. Thanks for taking time to help me out by the way.

Tanya Gupta Over a year ago

Correct. Here is the new link where I have changed the data set to reflect your particular data set. Hope this helps.

learningsql Over a year ago

Hey, thanks a lot. It did work, just had to change the column name in my csv. If there's a space in the column name, apparently it doesn't work. So I changed the Country Name header to CountryName and it worked!

Tanya Gupta Over a year ago

Great to hear! Could you accept the answer in that case ?

|

Collectives™ on Stack Overflow

Reading csv file using node.js

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related