clean-king-bee-emails.rb

orig = File.read("King Bee emails from Rachel.txt")

cleaned = orig
  .force_encoding('BINARY')
  .gsub("\xCA".force_encoding('BINARY'), '')
  .gsub(/\r+/, '; ')
  .gsub("\"; <", "\" <")
  .gsub(/; */, "\n")
  .gsub(/^"/, '')
  .gsub("\" ", ' <')
  .gsub(" <", ' ')
  .gsub(/>$/, '')
  .split("\n")
  .map do |m|
    friendly, _,  email = m.rpartition(' ')
    email.sub!(/^</, '')
    username = email.partition('@').first
    if friendly.include?(username)
      [username, email]
    else
      [friendly, email]
    end
  end

File.write("King Bee emails - separate.csv", cleaned.map { |*args| args.to_csv }.join)