William James
12/26/2006 9:14:00 PM
James Edward Gray II wrote:
> On Dec 26, 2006, at 3:15 AM, come wrote:
>
> > Since your file has a header, you could write something like :
>
> Obviously I am biased, but I sure think FasterCSV makes this kind of
> thing easier:
>
> >> require "rubygems"
> => false
> >> require "faster_csv"
> => true
> >> csv = <<END_CSV
> item,in_stock,reorder_limit
> "Real ""Rubies""",10,5
> Pearls,100,20
> Snakes,2,5
> END_CSV
> => "item,in_stock,reorder_limit\n"Real ""Rubies""",10,5\nPearls,100,20
> \nSnakes,2,5\n"
> >> result = FCSV.parse(csv, :headers => true, :header_converters
> => :symbol)
> => #<FasterCSV::Table:0x6e570c @mode=:col_or_row, @table=
> [#<FasterCSV::Row:0x6e5310 @header_row=false, @row=[[:item, "Real
> \"Rubies\""], [:in_stock, "10"], [:reorder_limit, "5"]]>,
> #<FasterCSV::Row:0x6e4f00 @header_row=false, @row=[[:item, "Pearls"],
> [:in_stock, "100"], [:reorder_limit, "20"]]>, #<FasterCSV::Row:
> 0x6e4af0 @header_row=false, @row=[[:item, "Snakes"], [:in_stock,
> "2"], [:reorder_limit, "5"]]>]
> >> puts re
> readline require__ result
> readlines require_gem retry
> redo require_gem_with_options return
> remove_instance_variable rescue
> require respond_to?
> >> puts result.map { |row| row[:item] }
> Real "Rubies"
> Pearls
> Snakes
> => nil
> >> result.each { |row| p row.to_hash }
> {:in_stock=>"10", :reorder_limit=>"5", :item=>"Real \"Rubies\""}
> {:in_stock=>"100", :reorder_limit=>"20", :item=>"Pearls"}
> {:in_stock=>"2", :reorder_limit=>"5", :item=>"Snakes"}
> => #<FasterCSV::Table:0x6e570c @mode=:col_or_row, @table=
> [#<FasterCSV::Row:0x6e5310 @header_row=false, @row=[[:item, "Real
> \"Rubies\""], [:in_stock, "10"], [:reorder_limit, "5"]]>,
> #<FasterCSV::Row:0x6e4f00 @header_row=false, @row=[[:item, "Pearls"],
> [:in_stock, "100"], [:reorder_limit, "20"]]>, #<FasterCSV::Row:
> 0x6e4af0 @header_row=false, @row=[[:item, "Snakes"], [:in_stock,
> "2"], [:reorder_limit, "5"]]>]
class String
def csv
(self + ",").scan(
/("(?:[^"]+|"")*"|[^,]*),/).flatten.
map{|s| s.gsub(/\A"|"\Z/,'').gsub(/""/,'"')}
end
end
data = DATA.readlines.map{|s| s.chomp.csv}
header = data.shift
p header
p data
puts
data.map{|a| header.zip(a).inject({}){|h,x|
h.merge({x[0].to_sym,x[1]}) }}.
each{|h| p h}
__END__
item,in_stock,reorder_limit
"Real ""Rubies""",10,5
Pearls,100,20
Snakes,2,5
--- output -----
["item", "in_stock", "reorder_limit"]
[["Real \"Rubies\"", "10", "5"], ["Pearls", "100", "20"], ["Snakes",
"2", "5"]]
{:in_stock=>"10", :reorder_limit=>"5", :item=>"Real \"Rubies\""}
{:in_stock=>"100", :reorder_limit=>"20", :item=>"Pearls"}
{:in_stock=>"2", :reorder_limit=>"5", :item=>"Snakes"}