From: "Eric C." <lists@...>
Date: 2012-04-19T05:10:51+09:00
Subject: Re: Converting CSV

Hi Christian:

The way you loop through the array, is with a Ruby iterator.  The method
"each" will iterate through anything generally:

require 'fastercsv'
array_of_arrays = FasterCSV.read("myfile.csv")

new_file = FasterCSV.new()
array_of_arrays.each do | item |
  new_file.add_row(item)
end
File.open("saved_file.csv", "w") { |f| new_file.dump }

It seems to me that there must be a better way to do what you're trying
to accomplish.  I don't know why you'd want to mess-around with csv
files in the first place.  I don't understand why the comma delimited
csv file is better than the original.  You could just use the original.

Also, if you're just doing a simple conversion, I'd just use simple ruby
code instead of having to learn everything about the CSV stuff:

File.open("original_file.txt", "r") do |f|
  new_file = File.open("new_file.csv", "w")
  f.each_line do |line|
    fields = line.split(";")
    fields.each { |fd| fd = "\"#{fd}\""
    new_file.write(fields.join(",")
  end
  new_file.close
end

Perhaps if you explain what you're trying to do with these files, I
could give you better advise.  Ruby has many tools to save objects like
YAML and JSON.  Generally its better not to mess around with formatting
files yourself.

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