From: Michael Blue <m_josenhans@...>
Date: 2011-09-01T04:31:00+09:00
Subject: csv parsing issue

I've generated a CSV Document using Open Office csv export.
When I read it, with ruby 1.8.7 everything is fine.

Code:

require 'csv'
reader = CSV.open("C:tmp/document.csv", "r")

headline = reader.shift
reader.each do |row|
  puts row
end
reader.close()

When I read the same document with ruby 1.9.2, then I get the following
error:

C:/Ruby192/lib/ruby/1.9.1/csv.rb:1886:in `block (2 levels) in shift':
CSV::MalformedCSVError (CSV::MalformedCSVError)
        from C:/Ruby192/lib/ruby/1.9.1/csv.rb:1863:in `each'
        from C:/Ruby192/lib/ruby/1.9.1/csv.rb:1863:in `block in shift'
        from C:/Ruby192/lib/ruby/1.9.1/csv.rb:1825:in `loop'
        from C:/Ruby192/lib/ruby/1.9.1/csv.rb:1825:in `shift'
        from C:/Dokumente und Einstellungen/josemi1/Eigene
Dateien/NetBeansProjects/Test/lib/main.rb:8:in `<main>'

And with jruby 1.9 I get the following error message:

CSV::MalformedCSVError: Unquoted fields do not allow \r or \n (line 2).
   shift at /home/michael/Jruby/jruby-1.6.0/lib/ruby/1.9/csv.rb:1893
    each at org/jruby/RubyArray.java:1572
   shift at /home/michael/Jruby/jruby-1.6.0/lib/ruby/1.9/csv.rb:1863
    loop at org/jruby/RubyKernel.java:1417
   shift at /home/michael/Jruby/jruby-1.6.0/lib/ruby/1.9/csv.rb:1825
    each at /home/michael/Jruby/jruby-1.6.0/lib/ruby/1.9/csv.rb:1768
  (root) at /home/michael/NetBeansProjects/Test/lib/main.rb:12

Hint:
ruby -e 'p File.read("/tmp/document.csv")'

"\"Projekt-ID\",<< cut off some data >>,\"letzte
Anderung\"\r\n\n\"\",\"HSW G04\",\"Prim\303\244rprojekt\",<< cut off
some data>>,,,\"zlebpa1\",07.03.2011\r\n"


Note: I have cut out irrelevant some data above and marked it with '<<
cut off some data >>'.


Questions:
Is the problem the '\r\n\n' above?
Is it a ruby error or an open office error?

-- 
Posted via http://www.ruby-forum.com/.