Parse tab delimited CSV file to array of hashes in Ruby 2.0

Question

I have the following code:

  def csv_to_array(file)
    csv = CSV::parse(file)
    fields = csv.shift
    array = csv.collect { |record| Hash[*fields.zip(record).flatten] }
  end

This creates an array of hashes, and works fine with comma separated values. I am trying to replicate this code for a tab delimited file. Currently, when I run the above code on my tab delimited file, I get something like this:

array[0] = {"First Name\tLast Name\tCode\t"=>"Luigi\tSmith\t1406\t"}

So, each array object is a hash as intended, but it has one key value pair - The entire tab delimited header row being the key, and the individual row of data being the value.

How can I alter this code to return an array of hashes with individual key value pairs, with the header of each column mapping to the row value for that column?

sites · Accepted Answer · 2014-04-30 02:26:07Z

5

It seems that the options you pass to parse are listed in ::new

>> CSV.parse("qwe\tq\twe", col_sep: "\t"){|a| p a}
["qwe", "q", "we"]

answered Apr 30, 2014 at 2:26

sites

21.9k18 gold badges91 silver badges147 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:50:29Z

1

Use the col_sep option, this post has the code: Changing field separator/delimiter in exported CSV using Ruby CSV

also checkout the docs: http://ruby-doc.org/stdlib-2.1.0/libdoc/csv/rdoc/CSV.html

lots of good stuff in the DEFAULT_OPTIONS section

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Apr 30, 2014 at 2:12

house9

20.7k9 gold badges57 silver badges62 bronze badges

Collectives™ on Stack Overflow

Parse tab delimited CSV file to array of hashes in Ruby 2.0

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related