Format data in CSV using ruby

Question

I have this kind of data in my csv file,

Albany, N.Y.
Albuquerque, N.M.
Anchorage, Alaska
Asheville, N.C.
Atlanta, Ga.
Atlantic City, N.J.
Austin, Texas
Baltimore, Md.
Baton Rouge, La.
Billings, Mont.
Birmingham, Ala.
Bismarck, N.D.
Boise, Idaho
Boston, Mass.
Bridgeport, Conn.

I want to convert it into this form:

Albany, N.Y.;Albuquerque, N.M.;Anchorage, Alaska;Asheville, N.C.;Atlanta, Ga.;Atlantic City, N.J.;Austin, Texas;Baltimore, Md.;Baton Rouge, La.;Billings, Mont.;Birmingham, Ala.;Bismarck, N.D.;Boise, Idaho;Boston, Mass.;Bridgeport, Conn.

What I have got so far:

require 'csv'

CSV.foreach("test.csv") do |row|
  puts row.inspect
end

But instead of getting a full row, it's just giving arrays, separated over coma? How is it possible to convert it in this manner?

With no quoting, you could just do File.open(fn).read.split(/\n/).join(';') — dawg
– dawg, Commented Aug 12, 2017 at 4:27

Sebastián Palma · Accepted Answer · 2017-08-12 03:48:54Z

1

Do you want only to read and print the data?, you could try using map and join:

p CSV.foreach('test.csv').map(&:join).join(';')
# => "Albany N.Y.;Albuquerque N.M.;Anchorage Alaska;Asheville N.C.;Atlanta Ga ...

answered Aug 12, 2017 at 3:48

Sebastián Palma

33.6k6 gold badges45 silver badges65 bronze badges

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

Comments

Sebastián Palma · Accepted Answer · 2017-08-12 04:06:16Z

1

The following should do it:

require 'csv'

result = Array.new
CSV.foreach('test.csv') do |row|
  result << row.join(',')
end
puts result.join(';')

edited Aug 12, 2017 at 4:06

Sebastián Palma

33.6k6 gold badges45 silver badges65 bronze badges

answered Aug 12, 2017 at 3:12

Imran Ali

2,2752 gold badges28 silver badges44 bronze badges

Comments

Cary Swoveland · Accepted Answer · 2017-08-12 06:14:21Z

1

There's no benefit to using the CSV class here. Just treat it like a regular text file.

File.read('test.csv').gsub('\n', ';')
  #=> "Albany N.Y.;Albuquerque N.M.;Anchorage Alaska;..."

answered Aug 12, 2017 at 6:14

Cary Swoveland

111k6 gold badges69 silver badges105 bronze badges

Collectives™ on Stack Overflow

Format data in CSV using ruby

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related