From: Dave Burt <dave@...>
Date: 2006-04-27T15:59:40+09:00
Subject: Re: Q about the FasterCSV

Pe�a wrote:
> Eric Luo [mailto:eric.wenbl@gmail.com] :
> 
> # In the csv file,
> # line 1,"1"
> # line 2,  "2"
> # Is it a bug or expected?
> 
> imho, a bug.

No, it's not a bug. CSV is a simple delimited format. It's delimited by
a comma character, not a comma then some arbitrary whitespace. That's
how Microsoft's Excel and Access and SQL Server parsers deal with it, too.

And, of course, Ruby's standard CSV library:

irb(main):001:0> require 'csv'
=> true
irb(main):002:0> CSV.parse 'line 1,"1"\nline 2, "2"\n'
CSV::IllegalFormatError: CSV::IllegalFormatError
        from D:/Apps/ruby/lib/ruby/1.8/csv.rb:607:in `get_row'
        from D:/Apps/ruby/lib/ruby/1.8/csv.rb:556:in `each'
        from D:/Apps/ruby/lib/ruby/1.8/csv.rb:127:in `parse'
        from (irb):2

Cheers,
Dave