From: kang cao <redmine@...>
Date: 2010-02-20T12:13:23+09:00
Subject: [ruby-core:28264] [Bug #2766] Cannot use CSV under windows 7

Bug #2766: Cannot use CSV under windows 7
http://redmine.ruby-lang.org/issues/show/2766

Author: kang cao
Status: Open, Priority: Normal
Target version: 1.9.1
ruby -v: ruby 1.9.1p378 (2010-01-10 revision 26273) [i386-mingw32]

I try to use Ruby under my windows 7 notebook. but I find that CSV cannot work. it alway throws " CSV::MalformedCSVError:Unquoted fields do not allow \r or \n(line 1)"
my system is windows 7
ruby 1.9.1p378(2010-01-10 revision 26273)[i386-mingw32]
error messages:
CSV::MalformedCSVError: Unquoted fields do not allow \r or \n (line 1).
        from C:/Ruby19/lib/ruby/1.9.1/csv.rb:1857:in `block (2 levels) in shift'

        from C:/Ruby19/lib/ruby/1.9.1/csv.rb:1847:in `gsub!'
        from C:/Ruby19/lib/ruby/1.9.1/csv.rb:1847:in `block in shift'
        from C:/Ruby19/lib/ruby/1.9.1/csv.rb:1809:in `loop'
        from C:/Ruby19/lib/ruby/1.9.1/csv.rb:1809:in `shift'
        from C:/Ruby19/lib/ruby/1.9.1/csv.rb:1754:in `each'
        from (irb):42
        from C:/Ruby19/bin/irb:12:in `<main>'

following is my code:

require 'CSV'
csvreader=CSV.open("D:\\tmp\\march.csv","r")
csvreader.each do |row|
caller=row[0]
callee=row[1]
puts caller, callee
end
csvreader.close

following is part of my data, we have ten thousand lines of this kind of data
59855500	13716050909	113	0.22
59855500	15801306235	9	0.22
59855500	13716050909	26	0.22
59855500	13581783508	15	0.22
59855500	13661273974	14	0.22
59855500	80101168	7	0.22
59855500	13716050909	25	0.22
59855500	13716050909	18	0.22
59855500	13716050909	71	0.22
59855500	13520988518	35	0.22
59855500	13716050909	83	0.22
59855500	13641324296	19	0.22
59855500	13716590624	9	0.22
59855500	95555	13	0.22


----------------------------------------
http://redmine.ruby-lang.org