I have a series of data files in the format:
ABC, 7/21/2005, 1825
CNC1, 7/28/2005, 34.21
BPR, 9/3/2006, 34872
I need to output it to a DIFFERENT Directory as
ABC, 20050721, 1825
CNC1, 20050728, 34.21
BPR, 20060903, 34872
code snippet below
Find.find(sourcedir) do |path|
if File.file? path
puts path
log.puts path
output = path.gsub(sourcedir, destdir) # name/dir change for
output file
data = File.readlines(path)
data.each { |row|
(machine, date, produced) = row.split(/,/)
(tmonth, tday, tyear) = date.split(///)
newdate = tyear + “%02d” % tmonth + “%02d” % tday
date = newdate
log2.puts machine + " , "+ date + " , " + newdate
}
log.puts "Outputting file " + output
open(output,‘w’) {|f| f.puts data}
end
end
I get the file output to the proper location, but the DATE format does
not change.
The log2 shows output in the proper format, the date and newdate ARE the
same.
The output file is still the same as the original input file.
Not sure what I am missing, but any assistance is appreciated.
the #each method does not modify the contents of the item that is being
looped over. I would use #map. You have the data you want to modify on
this array, so call data.map {|row| …} and do your text transformation
inside the block. The last line is what counts, so to transform data[]
as you have described, the last line in the block should be ‘machine + "
, "+ date + " , " + newdate’, you don’t need “puts” or anything.
Dan
Snoopy D. wrote:
BPR, 20060903, 34872
data.each { |row|
I get the file output to the proper location, but the DATE format does
not change.
The log2 shows output in the proper format, the date and newdate ARE the
same.
The output file is still the same as the original input file.
Not sure what I am missing, but any assistance is appreciated.
the #each method does not modify the contents of the item that is being
looped over. I would use #map. You have the data you want to modify on
this array, so call data.map {|row| …} and do your text transformation
inside the block. The last line is what counts, so to transform data[]
as you have described, the last line in the block should be ‘machine + "
, "+ date + " , " + newdate’, you don’t need “puts” or anything.
Dan
THANK YOU DAN
I ended up using
data.map! (|row|
as the control and added the line
machine + ", " + newdate + ", " + produced
as the last line in the block to get my desired result.
Thanks for your help
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.