A quick ruby script to take HTML exported from oneaccount.com and convert it to a CSV file of transactions for online banking.

one_account_to_csv.rb

# Usage: ruby one_account_to_csv.rb < html_dump.html > transactions.csv
# First row has column titles.

$text = readlines.join

puts "Date,Type,Merchant,Debit,Credit"
$text.scan %r{<tr class="content">.*?</tr>}m do |line|
  unless line =~ /colspan="5"/
    values = line.scan(%r{<td.*?>(?:<[^/].*?>)*(.*?)</}).map {|v| v.first}
    values.each do |value|
      value.gsub!(%r{<br>}," - ")
      value.gsub! /&nbsp;/, " "
      value.tr!(',','')
    end
    puts values.join ","
  end
end