script.rb

class Country < ActiveRecord::Base
end










file='news.txt'
def find_country_code(line)
   line[/\(\S*\)/,0].to_s.gsub(/[()]/, "")
end

def find_country(country_code)
    Country.where(country_code: country_code).last
end


 CSV.open("reworked.csv", "w") do |f|
    File.readlines(file).each do |line|
    country_code =  find_country_code(line)
    country =  find_country(country_code).country rescue "unknown"
    f << [country]
    end
end