How to create multiple columns per row in CSV with Ruby

Question

Ok, I have a hash which contains several properties. I wanted certain properties of this hash to be added to a CSV file.

Here's what I've written:

    require 'csv'
    require 'curb'
    require 'json'

    arr = []

    CSV.foreach('test.csv') do | row |
        details = []
        details << result['results'][0]['formatted_address']
        result['results'][0]['address_components'].each do | w |
            details << w['short_name']
        end
        arr << details
    end

    CSV.open('test_result.csv', 'w') do | csv |
        arr.each do | e |
            csv << [e]
        end
      end
    end

All works fine apart from the fact the I get each like so:

["something", "300", "something", "something", "something", "something", "something", "GB", "something"]

As an array, which I do not want. I want each element of the array in a new column. The problem is that I do not know how many items I'll have otherwise I could something like this:

CSV.open('test_result.csv', 'w') do | csv |
        arr.each do | e |
            csv << [e[0], e[1], ...]
        end
      end
    end

Any ideas?

It is indeed! Do you want to add as answer so I can mark it appropriately? Cheers — WagnerMatosUK, Jul 07 '15 at 13:52

score 3 · Accepted Answer · answered Jul 07 '15 at 13:57

3

Change csv << [e] to csv << e.

answered Jul 07 '15 at 13:57

limekin

1,934
1
12
15

How to create multiple columns per row in CSV with Ruby

1 Answers1