Skip to content

Instantly share code, notes, and snippets.

@johnlauck

johnlauck/csv_format_with_quotes.rb

Created October 20, 2010 15:18
Show Gist options
  • Save johnlauck/636615 to your computer and use it in GitHub Desktop.
Save johnlauck/636615 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
csv_format_with_quotes.rb
>> require 'fastercsv'
require 'fastercsv'
=> []
>> FasterCSV
=> FasterCSV
>> FasterCSV.parse
ArgumentError: wrong number of arguments (0 for 1)
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1226:in `initialize'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1226:in `new'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1226:in `parse'
from (irb):22
>> FasterCSV.parse(s)
FasterCSV::MalformedCSVError: Unclosed quoted field on line 1.
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1663:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `loop'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1526:in `each'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `to_a'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `read'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1229:in `parse'
from (irb):23
>> s = '"abc"def","ghi","hij"'
=> "\"abc\"def\",\"ghi\",\"hij\""
>> FasterCSV.parse(s)
FasterCSV::MalformedCSVError: Unclosed quoted field on line 1.
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1663:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `loop'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1526:in `each'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `to_a'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `read'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1229:in `parse'
from (irb):25
>> s = '"abc\\"def","ghi","hij"'
=> "\"abc\\\"def\",\"ghi\",\"hij\""
>> FasterCSV.parse(s)
FasterCSV::MalformedCSVError: Unclosed quoted field on line 1.
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1663:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `loop'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1526:in `each'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `to_a'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `read'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1229:in `parse'
from (irb):27
>> s = '"abc"def","ghi","hij"'
=> "\"abc\"def\",\"ghi\",\"hij\""
>> FasterCSV.parse(s)
FasterCSV::MalformedCSVError: Unclosed quoted field on line 1.
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1663:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `loop'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1526:in `each'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `to_a'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `read'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1229:in `parse'
from (irb):29
>> s = '"abcdef","ghi","hij"'
=> "\"abcdef\",\"ghi\",\"hij\""
>> FasterCSV.parse(s)
=> [["abcdef", "ghi", "hij"]]
>> puts s
"abcdef","ghi","hij"
=> nil
>> s = '"abc\"def","ghi","hij"'
=> "\"abc\\\"def\",\"ghi\",\"hij\""
>> puts s
"abc\"def","ghi","hij"
=> nil
>> FasterCSV.parse(s)
FasterCSV::MalformedCSVError: Unclosed quoted field on line 1.
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1663:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `loop'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1581:in `shift'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1526:in `each'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `to_a'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1537:in `read'
from /Users/john/.rvm/gems/ree-1.8.7-2010.02/gems/fastercsv-1.5.3/lib/faster_csv.rb:1229:in `parse'
from (irb):35
>> s = '"abc""def","ghi","hij"'
=> "\"abc\"\"def\",\"ghi\",\"hij\""
>> FasterCSV.parse(s)
=> [["abc\"def", "ghi", "hij"]]
>> FasterCSV.parse(s).each {|c| puts c}
abc"def
ghi
hij
=> [["abc\"def", "ghi", "hij"]]
>> CSV.parse(s).each {|c| puts c}
abc"def
ghi
hij
=> [["abc\"def", "ghi", "hij"]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment