From: Geoff <samekh@...>
Date: 2006-03-18T02:38:48+09:00
Subject: Re: csv updater

Cool, the puts command works, but when I tweak it to output this to a
file, the result is:

78,101,119
84,101,115,116,49
84,101,115,116,49
84,101,115,116,49
84,101,115,116,50
84,101,115,116,50
78,101,119

The tweak I used on the code is:

require "csv"
require "enumerator"

last_row = Array.new
out_csv = CSV.open("C:\\temp\\geoff\\filldown\\filldownNew.txt", "w")
output = ''
CSV.foreach("C:\\temp\\geoff\\filldown\\filldown.txt") do |row|
   puts( row.enum_for(:each_with_index).map do |cell, index|
     if cell.empty?
       last_row[index]
     else
       last_row[index] = cell
     end
   end.map { |output| "\"#{output}\""}.join(",") )
   out_csv << output
end

I'm getting the feeling I just don't understand programming and Ruby
enough at this point and need to re-read some intro material. Thanks a
bunch for spending time on this problem for me, I do appreciate it!