Format a .CSV export from Google Docs for SUGARfx Rolling Credits

parse_credits.rb

require 'csv'

CSV.read("credits.csv").each_with_index do |line, i|
  line.each { |s| s.gsub!("'", "’") unless s.nil? }

  if i == 0
    puts "[TTL]#{line[0].upcase!}"
  elsif line.compact.length > 0
    puts "\n" if line[0]
    line[1].upcase! if line[1]
    puts line.join(' * ').strip
  else
    puts "\n"
  end
end