Shell Programming and Scripting

Hi
I'm really new to this so sorry if this is trivial

What I'm trying to do is take a file with 3 columns of numbers and cat all the entries of the second and third columns which have the same entry in the first column into a file with the number from the first column in the name. So say

1 3 4
1 3 5
1 4 6 > something1.txt

2 3 5
2 5 7 > something2.txt

Tried using awk but I'm not very good

Code:

for i in 1 2 3 4 5 6 7 8 9 0; do cat file | egrep "^$i" >$i ; done

As an aside, cat file | egrep pattern is better expressed as egrep pattern file, without the cat.

With awk (input file is read only once) :

Code:

awk '{print > "something" $1 ".txt"}' inputfile

Jean-Pierre.

Brilliant! Works like a dream

And if I wanted to use the input filename in the output file's names? How owuld I do that?

I have the whole thing in a big script:

cat listoffilenames | while read line; do awk{the stuff above but also want the $line name in here too but it doesnt evaluated $line for me, instead prints $line} $line

Basically what I am asking is

How do I get this to work:

awk '{print > "something$inputfile" $1 ".txt"}' $inputfile

?

I've tried
awk '{print > "something"$inputfile"" $1 ".txt"}' $inputfile

But doesnt work?