I don't have much time to help right now, but this might be helpful:

Sometimes the easiest way to make a list of unique values is to use hash
keys.  As an example, the below code will take an array of strings and
assign each as a hash key.  Since adding duplicate keys basically does
nothing in this case, you can use the keys of the resulting hash as a
list of unique items.  You can also use map() if that is easier for you,
but to me this makes more sense, even though it's a few more lines of
code.

        my @input = qw(text1 text2 text3 text5 text2 text9 text3);
        my %unique;
        foreach my $item(@input){
           $unique{$item} = 1;
        }
        
        foreach my $key(sort keys %unique){
           print "$key\n";
        }

That might help with one part of the problem.  For the rest, one way to
go about it would be to use W1, W2, etc, as keys in a hash of arrays.

Example:

        $hash{W1} = [text1,text2,text3];

That should be enough to get started.

-----Original Message-----
From: Andrej Kastrin [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 19, 2006 10:55 PM
To: beginners@perl.org
Subject: Re: Transform column into row

Andrej Kastrin wrote:

<snip>

So, what is the intuition to combine | merge | join 2 tables. E.g., if 
we have table;

ID001 W1, W2, ...
ID002 W5, W9, ...
ID003 W3, W2, W10, ...

Then the second table looks like:

W1 text1, text2, text3
W2 text2, text5, text1
W3 text3, text4

The result must be:
ID001 text1,text2,text3,text5 #combine elements from W1 and W2 from 
first table
ID002 ...
ID003 ...

I go to study "Perl Programming" now and thank's for all suggestions...

Cheers



--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>


Reply via email to