gistfile1.rb

#!/usr/bin/env ruby

require 'rubygems'
require 'fileutils'
require 'fastercsv'


csv_data = []
arr = Array.new
input_file= FasterCSV.open("input.csv", "r")
input_file.each_line { |line|
 csv_data = line.split(',')
 csv_data[1].tr_s("$","").split
 csv_data[1].tr_s(",","").split
 csv_data[2] = csv_data[2].match(/^(\d{2})(\d{2})(\d{4})$/)
 csv_data[2] = "#{csv_data[2][2]}/#{csv_data[2][1]}/#{csv_data[2][3]}"
 arr.push(csv_data)
 }
input_file.close


output_file = FasterCSV.open("output.csv", "w") do |csv|
@arr.each do |array|
csv << array
end
end

output_file.close