Very Computer

I have a file in the following format:

Name    Score   Average Score

Matt    100
Fred    56      66
John    60              
Simon   56      55

I want to sort it as follows:

Name    Score   Average

Simon   56      55
Fred    56      66
John    60              
Matt    100

First the score is sorted and then the average scores are sorted
within the people with average scores.
Ive been trying to figure this out for a while, using awk and sort,
but with no luck.
Any help would be much appreciated!
Mant thanks,

Ed.

sort -k 2,2n -k 3,3n

This will handle the lines with the scores; you'll need to deal with the
column headings separately.

--

Genuity Managed Services, Woburn, MA
*** DON'T SEND TECHNICAL QUESTIONS DIRECTLY TO ME, post them to newsgroups.
Please DON'T copy followups to me -- I'll assume it wasn't posted to the group.

Quote:>I have a file in the following format:

>Name        Score   Average Score

>Matt        100
>Fred        56      66
>John        60              
>Simon       56      55

>I want to sort it as follows:

>Name        Score   Average

>Simon       56      55
>Fred        56      66
>John        60              
>Matt        100

>First the score is sorted and then the average scores are sorted
>within the people with average scores.
>Ive been trying to figure this out for a while, using awk and sort,
>but with no luck.

Try looking in the man page for 'sort' - "man sort"

'sort' has the ability to sort by more than one key at a time
so you shouldn't need 'awk'.

Quote:>Any help would be much appreciated!
>Mant thanks,

>Ed.

seeyafrom
laura

--
alt.fan.madonna |news, interviews, discussion, writings
                |chat, exchange merchandise, meet fans....
                |Get into the groove baby you've got to... check us out!

man sort        (-k and -n options)
--

Linux solution for data management and processing.