csv reaad illegal quoting in line x

问题描述：

    在做csv导入的时候遇到了  "Illegal quoting in line 11227."的错误。

通过检查csv发现这行有个”“，通过测试发现，”“导致报错。

 

通过查阅stackoverflow 发现相同问题https://stackoverflow.com/questions/9864064/csv-read-illegal-quoting-in-line-x

I had this problem in a line like 123,456,a"b"c

The problem is the CSV parser is expecting ", if they appear, to entirely surround the comma-delimited text.

Solution use a quote character besides " that I was sure would not appear in my data:

CSV.read(filename, :quote_char => "|")

CSV.read(filename, liberal_parsing: true)

 

 

Try forcing double quote character " as quote char:

require 'csv'
CSV.foreach(file,{headers: :first_row, quote_char: "\x00"}) do |line|
  p line
end