Q:

what is the proper way to import a csv in ruby?

There are soo many inherent problems with csv, 1) your columns can't have commas, so you have to encapsulate them with quotes "", and then once you encapsulate them with quotes, you have to already escape the quotes within a sentence by using \"
What is the easiest way to parse a csv file?  I reverted to doing semi-colon separated files but those are troublesome when working in excel, so now i'm back to csv files.

A:

Have you tried  http://ruby-doc.org/stdlib-1.9.2/libdoc/csv/rdoc/CSV.html.
You can also look at http://fastercsv.rubyforge.org/

