# CSV parsing/Faster CSV

**URL:** <https://www.ruby-forum.com/t/csv-parsing-faster-csv/188809>\
**Category:** Rails\
**Created:** [May 18, 2010, 7:44pm UTC](https://www.ruby-forum.com/t/csv-parsing-faster-csv/188809 "2010-05-18T19:44:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![spex2004](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/e9c0ed/32.png) [@spex2004](https://www.ruby-forum.com/u/spex2004)\
**Post date:** [May 18, 2010, 7:44pm UTC](https://www.ruby-forum.com/t/csv-parsing-faster-csv/188809/1 "2010-05-18T19:44:30Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![spex2004](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/e9c0ed/32.png) [@spex2004](https://www.ruby-forum.com/u/spex2004)\
**Post date:** [May 18, 2010, 8:17pm UTC](https://www.ruby-forum.com/t/csv-parsing-faster-csv/188809/2 "2010-05-18T20:17:31Z")

</div>

On May 18, 2010, at 1:44 PM, Spec Ex wrote:

> 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 B.  
[http://agileconsultingllc.com](http://agileconsultingllc.com)  
removed\_email\_address@domain.invalid

> **[Launch Scout Custom Software Development & Software Consulting](https://launchscout.com/)**
>
> We solve digital problems through custom software development and design for the web—apps, mobile, desktop and devices.

removed\_email\_address@domain.invalid