Hi,
I have a csv file, which has the following data, for example:
test.csv
line 1, “1”
line 2, “2”
And I use the following code snippet to parse this file,
require ‘fastercsv’
FasterCSV.read(“test.csv”)
unfortunately, It failed and complained that:
FasterCSV::MalformedCSVError: Unclosed quoted field on line 1.
e:/ruby/lib/ruby/gems/1.8/gems/fastercsv-0.2.0/lib/faster_csv.rb:1165:in
shift' e:/ruby/lib/ruby/gems/1.8/gems/fastercsv-0.2.0/lib/faster_csv.rb:1090:in
shift’
e:/ruby/lib/ruby/gems/1.8/gems/fastercsv-0.2.0/lib/faster_csv.rb:1040:in
each' e:/ruby/lib/ruby/gems/1.8/gems/fastercsv-0.2.0/lib/faster_csv.rb:1051:in
read’
e:/ruby/lib/ruby/gems/1.8/gems/fastercsv-0.2.0/lib/faster_csv.rb:840:in
read' e:/ruby/lib/ruby/gems/1.8/gems/fastercsv-0.2.0/lib/faster_csv.rb:790:in
open’
e:/ruby/lib/ruby/gems/1.8/gems/fastercsv-0.2.0/lib/faster_csv.rb:840:in
`read’
I’m wondering what the real problem is,
Do I really need to escape the double quote before pass the file to
read?