Warrior X-Fit Fight Data Conversion

Warrior X-Fit Spreadsheet Import

curdate = ""

data = File.open("fights.txt").read

data.gsub!(/^(Month|Name|Red|Gray).*\n/, '')
data.gsub!(/\t/, '","')
data.gsub!(/^/, '"').gsub!(/$/, '"')
data.gsub!(/(\w+), (\w+)/, "\\2 \\1")
data.gsub!(/(,"")*$/, '')

data.split("\n").each do |line|
  if line.include?(",")
    puts curdate + "," + line
  else
    curdate = line
  end
end