On mac osx, turn a mysql console result into something that can be pasted into excel

mysql2excel

#!/usr/bin/env ruby
# put in /usr/local/bin/mysql2excel
buffer = []
input = `pbpaste`.strip
input.split("\n").each do |line|
  unless line =~ /^([+-]+|\d+ rows in set.*|mysql>)$/
    buffer << line.gsub(/^[|]/, "").gsub(/[|]$/, "").strip.gsub(/\s*[|]\s*/, "\t")
  end
end
IO.popen "pbcopy", "w" do |pipe|
  pipe.puts buffer.join("\n")
end
puts "Copied to clipboard"