CSV Parser adding columns on empty values

Question

So I having problems with my csv-parser that is reading values where it adds a column on empty cells from a csv file. It gives an error of

column header mismatch expected: 17 columns got: 18

For now I have to go in the csv file and backspace a comma to match the columns. I know is a parse csv issue, has anyone encounter this? below is my csv code.

function  readStream () {
          let stream  = fs.createReadStream("accounts.csv");

          fast
              .fromStream(stream, {
                headers: true
              })
              .on("data" , fetchYelp, fetchWhitePages, fetchGooglePlace, writeStream
              )
              .on("end", function () {

                console.log("Done Reading");
              });
      }

readStream();

Terry Lennox · Accepted Answer · 2019-03-14 18:25:22Z

1

Could you try using the discardUnmappedColumns option, e.g. ? That works for me!

function  readStream () {
    let stream  = fs.createReadStream("accounts.csv");

    fast
        .fromStream(stream, {
          headers: true,
          discardUnmappedColumns: true
        })
        .on("data" , fetchYelp, fetchWhitePages, fetchGooglePlace, writeStream ) {
        })
        .on("end", function () {

        console.log("Done Reading");
        });
}

readStream();

edited Mar 14, 2019 at 18:25

answered Mar 14, 2019 at 16:45

Terry Lennox

30.9k5 gold badges37 silver badges45 bronze badges

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

2 Comments

Chris Over a year ago

what does the below function do? function(d){ console.log(d); {

Terry Lennox Over a year ago

Oh sorry, that's just dumping out the rows, just replace with your original callback!

Collectives™ on Stack Overflow

CSV Parser adding columns on empty values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related