CSV file sanitizer, which will remove error-rows and create a new sanitized file

remove_invalid_rows_from_csv.rb

require 'csv'

valid_rows = 0
invalid_rows  = 0
error_file = File.open("/path/to/invalid.csv", "w")
correct_file = File.open("path/to/valid.csv", "a+")
File.open("path/to/original.csv").each do |line|
  begin
    print "."
    if CSV.parse_line(line)
      valid_file.write(line)
      valid_rows += 1
    end
  rescue Exception => e
    invalid_rows += 1
    invalid_file.write(line)
    e.backtrace.each{ |b| print b + "\n" }
  end
end

p "valid_rows: #{valid_rows}"
p "invalid_rows: #{invalid_rows}"