Uses ruby's built in CSV Reader which will find " escaped columns

gistfile1.rb

require 'csv'

file = "db/commission_junction/2087028_18584_20080827.csv"
rows = CSV::Reader.parse(File.open(file)).to_a
cols = rows.shift
collection = rows.collect do |row|
	Hash[*cols.zip(row).flatten]
end

puts collection.first.inspect