CSVからURLを抽出してCSVファイルに書き出すスクリプト

export-url-from-about.rb

# "12345", "long text...."
# "12346", "long text...."
require 'csv'
require 'uri'

CSV.open('url.csv', 'wb', force_quotes: true) do |output|
  CSV.read('about.csv', encoding: 'UTF-8:UTF-8', header_converters: nil).map do |input|
    tmp = []
    tmp << input[0]
    tmp <<  URI.extract(input[1])
    output << tmp.flatten
  end
end