Ruby unable to parse a CSV file: CSV::MalformedCSVError (Illegal quoting in line 1.)
quote_chars = %w(" | ~ ^ & *)begin @report = CSV.read(csv_file, headers: :first_row, quote_char: quote_chars.shift)rescue CSV::MalformedCSVError quote_chars.empty? ? raise : retry endit's not perfect but it works most of the time.
N.B. CSV.parse takes the same parameters as CSV.read, so either a file or data from memory can be used
I just had an issue like this and discovered that CSV does not like spaces between the col-sep and the quote character. Once I removed those everything went fine.So I had:
12, "N", 12, "Pacific/Majuro"but once I gsubed out the spaces using
.gsub(/,\s+\"/,',\"')resulting in
12,"N", 12,"Pacific/Majuro"everything went fine.