From: ideal one <idealone5@...>
Date: 2011-10-06T02:25:31+09:00
Subject: Read thru Csv file and store it in variables

HI All,
        I need to read thru Excel file saved as CSV. Exclude the header
and store the data in variables.
Based on the number of records the script has to go thru that number of
iterations.

I tried just s simple faster_csv code, which isnt working!!
<code>
require 'rubygems'
require 'faster_csv'

path = "C:/Users/test/Desktop/data.txt"

FasterCSV.foreach(path) do |row|
    puts row

  end
<code>

<Error>
C:/Program
Files/Ruby/lib/ruby/gems/1.9.1/gems/fastercsv-1.5.4/lib/faster_csv.rb:13:in
`const_missing': Please switch to Ruby 1.9's standard CSV library.  It's
FasterCSV plus support for Ruby 1.9's m17n encoding engine.
(NotImplementedError)
<ERROR>

I am not aware of this error, Can any of you plz recommend better way to
achieve the result.

Thanks

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