copie-privee.csv

Gemfile

gem 'pdf-reader'

to_csv

#!/usr/bin/env ruby

require 'pdf-reader'
require 'open-uri'
require 'csv'

io = open('http://www.copiefrance.fr/files/declaration_tarif/liste_societes_exonerees_site-FR-CF.pdf')
reader = PDF::Reader.new(io)

OMAGAD = /^\s+([0-9]{3}.[0-9]{4}.[0-9]{3})\s+(.+)\d{5}/

'copie-privee.csv'.tap do |filename|
  File.delete(filename) if File.exist?(filename)
  CSV.open(filename, 'wb') do |csv|
    reader.pages.each do |page|
      page.text.each_line do |line|
        if OMAGAD =~ line
          match = OMAGAD.match(line)
          csv << [match[1], match[2]]
        end
      end
    end
  end
end