Why can't I parse this CSV file inside of node.js?

Question

Here's my code:

var options = {

    rowDelimiter: 'windows',
    encoding: 'ascii'

}

var data = fs.readFileSync(localFolder+'/'+file, 'ascii');                  

console.log(data);

csv().from.string(data, options).to.array(function(data, count) {

    console.log(data);

});

The first console.log returns the following data:

"Filename","DID#","Document Type","Date Sent","School","First Name","Middle Name","Last Name","DOB","SSN","Application #","Common App ID","RH CEEB","Class Of","Years Attended" "TR58A3D.pdf","TR58A3D","Transcript","07/19/2012","zz Screaming Eagle High School","Kim","","Smith","05/05/1995","","","","555555","2013","" "TR58AQH.pdf","TR58AQH","Transcript","07/19/2012","zz Screaming Eagle High School","Jon","","Sink","05/09/1996","","","","555555","2015",""

[scott@localhost]$ file transcripts/index_07_19_2012_1043460.csv transcripts/index_07_19_2012_1043460.csv: ASCII text, with CRLF line terminators

The second console.log doesn't print anything to my console. Anyone have any ideas why it's not parsing the CSV?

.from.path expects a file path, not a string of data, but I don't know how to pass options using just .from(data). — Aaron Dufour
– Aaron Dufour, Commented Jul 1, 2013 at 20:47
Sorry, I tried from.string(), and that doesn't appear to be working either. — sluther
– sluther, Commented Jul 1, 2013 at 22:21

sluther · Accepted Answer · 2013-07-03 01:02:51Z

1

The problem was the value for rowDelimiter option. It needs to be the actual line break character used - i.e.: \r\n or \r.

answered Jul 3, 2013 at 1:02

sluther

1,72420 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Why can't I parse this CSV file inside of node.js?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related