Unix Awk

[PoxKing]

There is a file that contains:

MFT 90
FFF 87
SIA 76
SSS 94

This file can be called Data.txt

I'd like to know how to use awk to compare the second fields and return the line with the biggest number.

Many thanks.

 

[PHV]

awk '$2>m{m=$2;x=$0}END{print x}' Data.txt

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PoxKing]

Thanks a lot even you did it wrong
I added if and it worked.

 

[PHV]

you did it wrong
Really ?
I added if
Where ?

 

[PoxKing]

It was not totally really wrong, but needed 'if'

awk {if ($2>m)
{m=$2;x=$0}
END{print x}' Data.txt

the previous command didn't work.

 

[PHV]

I highly doubt that your posted code don't raise an error ...

 

[PoxKing]

awk {if ($2>m)
{m=$2;x=$0}}
END{print x}' Data.txt
it works, tested.

 

[PHV]

it works, tested
Again, not as posted.

It's why I believe you didn't test my exact code.

 

[Annihilannic]

No if is required because there is an implicit if before every expression { code block } pair.

Annihilannic.