ruby中的csv文件编码问题(csv file encoding issue in ruby)

 我使用ruby解析csv文件并收到错误 
 
invalid byte sequence in utf-8 csv
 
 我试过编码选项 
 
    CSV.foreach(path, {headers: true, encoding: 'windows-1251:utf-8'}) do |row|
        new_row = {}
        headers = []
        row.each do |k,v|
            headers << k
            v = v.force_encoding('UTF-8') || ''
            v.gsub! "\xE2\x80\x96", "-"
            v.gsub! "\xE2\x80\x93", "-"
            v.gsub! "\xE2\x80\x94", "-"
            v.gsub! "\xE2\x80\x95", "-"
            v.gsub! "\xE2\x80\x98", "'"
            v.gsub! "\xE2\x80\x99", "'"
            v.gsub! "\xE2\x80\x9C", "\""
            v.gsub! "\xE2\x80\x9D", "\""
            v.gsub! "\xE2\x80\xA6", "..."
            v.gsub! "\x0D\x0A", "\n"
            v.gsub! "\xC2\xA0", " "
            v.gsub! "\xC2\xB0", " "

            new_row[k] = v
        end

        output_csv.puts headers if output_csv.header_row?
        output_csv.puts new_row
    end
 
 现在我结束了 
 
incompatible encoding regexp match (ASCII-8BIT regexp with UTF-8 string)
 
 在CSV文件中引发此问题的字符串是“G ran” 
 
 下面是示例输入行 
 
David Evans & Assocs    www.deainc.com  13858534    jpv@deainc.com  G�ran   Volk    5034990383
 
 任何人都可以建议我如何解决这个问题。 

I parsing a csv file using ruby and getting an error
 
invalid byte sequence in utf-8 csv
 
I tried with encoding option
 
    CSV.foreach(path, {headers: true, encoding: 'windows-1251:utf-8'}) do |row|
        new_row = {}
        headers = []
        row.each do |k,v|
            headers << k
            v = v.force_encoding('UTF-8') || ''
            v.gsub! "\xE2\x80\x96", "-"
            v.gsub! "\xE2\x80\x93", "-"
            v.gsub! "\xE2\x80\x94", "-"
            v.gsub! "\xE2\x80\x95", "-"
            v.gsub! "\xE2\x80\x98", "'"
            v.gsub! "\xE2\x80\x99", "'"
            v.gsub! "\xE2\x80\x9C", "\""
            v.gsub! "\xE2\x80\x9D", "\""
            v.gsub! "\xE2\x80\xA6", "..."
            v.gsub! "\x0D\x0A", "\n"
            v.gsub! "\xC2\xA0", " "
            v.gsub! "\xC2\xB0", " "

            new_row[k] = v
        end

        output_csv.puts headers if output_csv.header_row?
        output_csv.puts new_row
    end
 
now i'm ended up with 
 
incompatible encoding regexp match (ASCII-8BIT regexp with UTF-8 string)
 
The string which is raising this issue in CSV file is "G�ran"
 
Below is the sample input row
 
David Evans & Assocs    www.deainc.com  13858534    jpv@deainc.com  G�ran   Volk    5034990383
 
Can anyone suggest me how to solve this issue. 

原文：https://stackoverflow.com/questions/28495462