Rails: Use more than 1 col_sep

Question

As stated in this documentation I can change the standard col_sep e.g. from "," to ";".

How can I alter this to use both "," and ";" as a col_sep.

My actual code:

def process!
  @imported_count = 0
  CSV.foreach(file.path, headers: true, header_converters: :symbol, col_sep: ",") do |row|
    order = Order.assign_from_row(row)
    if order.save
      @imported_count += 1
    else
      errors.add :base, "Line #{$.} - #{order.errors.full_messages.join(",")}"
    end
  end
end

Thanks in Advance!

Workaround found here: http://stackoverflow.com/a/7832423/5243191 — CottonEyeJoe, Jan 13 '16 at 09:07

score 1 · Accepted Answer · answered Jan 12 '16 at 16:04

col_sep only accepts one value. You can see examples of how it's used here:

http://rxr.whitequark.org/mri/source/lib/csv.rb (lines 1654 and 1803 are a couple examples)

One workaround could be replacing all instances of one separator value with another by using something like gsub. Not the silver bullet you were hoping for, but depending on your requirements it could do the trick!

Rails: Use more than 1 col_sep

1 Answers1