UNIX for Dummies Questions & Answers

Hi.. Just a question:
Let's say we have three files:

test1.txt
---------
11111111 6
12121212 7
12345678 4
11112222 8

test2.txt
---------
11111111 5
12345678 6
11112222 6

test3.txt
---------
12345678 6
12121212 8
11112222 6

Question: How do I produce an output file, for example "result.txt" that has the following output:

result.txt
---------
11111111 6 5
11112222 8 6 6
12121212 7 8
12345678 4 6 6

using join in UNIX?

Thanks..

---------- Post updated at 11:42 PM ---------- Previous update was at 11:07 PM ----------

please answer.. im in an urgent.. thanks

Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

Thank You.

The UNIX and Linux Forums.

If you want to use perl
here is the sol

Code:

 cat test1 test2 test3 |
 perl -e '
while (<>){ 
chomp;
my ($id, $num) =split("\ ");
push @{$hash{$id}}, $num;
}
foreach (sort keys %hash){ 
print "$_\t"; 
map {print "$_ "} @{$hash{$_}}; 
print "\n";
}'

HTH,
PL

Thank you for answering..

but i need an answer using "JOIN"..

edit by scottn: to need an answer using join specifically suggests to me "homework question". Thread closed.