From: William James <w_a_x_man@...>
Date: 2008-05-02T11:25:06+09:00
Subject: Re: parsing a file

On May 1, 4:07 pm, Adam Masiarek <a...@masiarek.com> wrote:
> Input file format (three columns, tabs delimited):
> A \t X1, X2 \t Z1, Z2
> B \t X3 \t Z3
> C \t X4, X5, X6 \t Z4, Z5, Z6
>
> Expected file format:
> A  X1  Z1
> A  X2  Z2
> B  X3  Z3
> C  X4  Z4
> C  X5  Z5
> C  X6  Z6
>
> My code:
> a = Array.new()
> x = Array.new()
> z = Array.new()
> s = String.new()
> open("c:\\temp\\a.txt").each {|e|
>     a = e.split("\t")
>     x = a[1].split(",")
>     z = a[2].split(",")
>     x.each_index {|i|
>         s = a[0] +"\t" + x[i] +" \t" + z[i]
>         puts s
>     }
>
> }
>
> Can this be done in a more elegant manner?


IO.foreach("data"){|line|
  k, *vals = line.split( "\t" )
  vals.map{|x| x.split( "," )}.transpose.each{|x|
    puts [k, *x].join( "\t" ) }
}