CSV parsing/Faster CSV

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!

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
http://gaslightsoftware.com
  rab@GaslightSoftware.com