How to Filter a file using awk and sort commands based on second field,Linux?

Question

I have a file like below which I have sorted based on the username field.

1234    200   suresh
5678    150   murali
8543    200   sanjith
5678    100   suresh
1456    400  murali

I am trying to remove the rows which have the lowest score for the same usernames. So I want to have the output using Shell Script.

1234    200   suresh
5678    400   murali
8543    200   sanjith

Hi there, please format your examples and state what you have tried. And a pro-tip "info coreutils" shows you kinda-man-pages for some really helpful commands. — Felix
– Felix, Commented Feb 11, 2016 at 6:32
why does 5678 400 murali in your output. Shouldn't it be 1456 400 murali? — Utsav
– Utsav, Commented Feb 11, 2016 at 6:39
Possible duplicate of stackoverflow.com/questions/22822465/… — tripleee
– tripleee, Commented Feb 11, 2016 at 9:57

anubhava · Accepted Answer · 2016-02-11 07:28:18Z

1

You can use awk's associative array:

awk '$2>m[$3]{m[$3]=$2; r[$3]=$0} END{for (i in r) print r[i]}' file
1456    400  murali
1234    200   suresh
8543    200   sanjith

answered Feb 11, 2016 at 7:28

anubhava

791k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1