Question

我有这样的档案。

ID Name  Car
1  Mike  Honda
2  Adam  Jim

These values are tab delimited, and from this I want to parse it in Ruby and put it into my database.

我已尝试如下:

require  csv 

CSV.foreach("public/files/example.tab", {:col_sep => "	"}) do |row|
  @stuff = row[0]
end

但@stuff 只是归还整个物体,似乎没有使用第1栏所列分离器。

它也没有考虑到第一行是头盔。

我怎么能够把一个被制成的档案划归Ruu,我如何告诉它第一行是头盔?

Answer 1

我成功地利用了FerCSV和Rub.1.8.7,我认为它现在成为1.9个核心图书馆:

table = FasterCSV.read(result_file.to_file.path, { :headers => true, :col_sep => "	", :skip_blanks => true })
unless table.empty?
    header_arry = Array.new
    table.headers.each do |h|
      #your header logic, e.g.
      # if h.downcase.include?  pos 
        # header_arry <<  position 
      # end
      # simplest case here
      header_arry << h.downcase
      #which produces an array of column names called header_arry
    end

    rows = table.to_a
    rows.delete_at(0)
    rows.each do |row|
      #convert to hash using the column names
      hash = Hash[header_arry.zip(row)]
      # do something with the row hash
    end
  end

Answer 2

Update

https://github.com/tilo/smarter_csv/"rel=“nofollow”https://github.com/tilo/smarter_csv/。

Previous Answer

这里,我是怎样做的(一长,我把CSV.read或CSV.parse归还的“阵列”转换成“斜体”,使数据更像主动记录数据,更便于日后处理。

require  csv 

def process(csv_array)  # makes arrays of hashes out of CSV s arrays of arrays
  result = []
  return result if csv_array.nil? || csv_array.empty?
  headerA = csv_array.shift             # remove first array with headers from array returned by CSV
  headerA.map!{|x| x.downcase.to_sym }  # make symbols out of the CSV headers
  csv_array.each do |row|               #    convert each data row into a hash, given the CSV headers
    result << Hash[ headerA.zip(row) ]  #    you could use HashWithIndifferentAccess here instead of Hash
  end
  return result
end

# reading in the CSV data is now just one line:

csv_data = process( CSV.read( filename , { :col_sep => "	"}) )

 => [{:id=>"1", :name=>"Mike", :car=>"Honda"}, 
     {:id=>"2", :name=>"Adam", :car=>"Jim"}]

you can now process the data like this:

csv_data.each do |hash|
  # ...
end

Update

Previous Answer

See also:

友情链接