get_transactions.rb

#!/Users/tim/.rvm/rubies/ruby-2.1.5/bin/ruby

file_in = ARGV[0]

puts "importing #{file_in} . . . "

# ensure the file has the correct line breaks
system("perl -pi -e 's/\r/\n/g' #{file_in}")

out_file = "#{file_in.gsub('.txt','')}_out.csv"

File.open(out_file, 'w') do |f_w|  
  	# use "\n" for two lines of text  
	File.open(file_in, "r") do |f|
		f.each_line do |line|
		  if line =~ /^(\d{2}\/\d{2}) (.*) (\-?\d+\.\d+)/
		  	data = "#{$1}, #{$2}, #{$3}"
		  	f_w.puts data
		  	puts data 
		  end
		end
	end
end

puts "created #{out_file}"