Rails parse csv separtor ¦

Question

i have csv file with strange format

2783¦Larson and Sons
967¦Becker Group
333¦Rolfson LLC

I have tried to do this

CSV.foreach("#{Rails.root}/csv_files/suppliers.csv") do |supplier|
  p supplier[0]
end

but have got a string "2783¦Larson and Sons"

How to separate values? For example will return

supplier[0] #=> "2783"
supplier[1] #=> "Larson and Sons"

You can specify the delimiter via CSV.for_each(filename, col_sep: '¦') do .... See CSV.new for available options. — Stefan
– Stefan, Commented Aug 28, 2018 at 11:58

Aleksei Matiushkin · Accepted Answer · 2018-08-28 11:45:50Z

1

Why would you expect CSV to know how to handle this weird input? You should explicitly specify the encoding and the column separator.

CSV.read("#{Rails.root}/csv_files/suppliers.csv",
      encoding: Encoding::ISO_8859_1,
      col_sep: "\xC2\xA6".force_encoding(Encoding::ISO_8859_1)) do |supplier|
  puts supplier.inspect
end
#⇒ [["2783", "Larson and Sons"],
#   ["967", "Becker Group"],
#   ["333", "Rolfson LLC"]]

answered Aug 28, 2018 at 11:45

Aleksei Matiushkin

121k12 gold badges109 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Stefan Over a year ago

Why do you expect the CSV file to be ISO 8859-1 encoded? And where does \xC2 come from?

Aleksei Matiushkin Over a year ago

@Stefan I just showed an approach, I assume OP knows better what encoding to use. \xC2 came from reverse engineering :)

Collectives™ on Stack Overflow

Rails parse csv separtor ¦

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related