CSV parsing/Faster CSV

rubyonrails-talk
1

Hello,

I'm currently using FasterCSV to parse CSV files. Problem I have is that currently, I have to go through a two step process. I receive the CSV file, I have to open it, and then Save it as CSV (MSDOS) format for FasterCSV to read it without errors. If i try to submit it raw, my application throws me an exception (either, Malformed CSV Error, or, CSV file error).

Is there something I am missing from FasterCSV. Maybe someway to make it universally compatible to all CSV formats? Or is there a better CSV Parser out there for RoR that I can use?

Any help would be extremely appreciated.

Thanks!

2

Just because you can open it with (I assume) Excel, don't think that the CSV file started out valid. Excel will happily digest lots of non-standard CSV data without complaint.

Take a look at the before and after versions of your CSV or put the original in a gist or pastie if you need more help.

-Rob

Rob Biedenharn http://agileconsultingllc.com   Rob@AgileConsultingLLC.com

  rab@GaslightSoftware.com