Shell Programming and Scripting

Howdy, I'm new to awk and am writing scripts primarily in ksh. What I'm trying to do is use awk to go through a list which contains multiple fields and four columns. I need awk to find and print a couple of columns that contain the lowest value.

e.g.
Jim ABC xyz 12.5
Jack ACB jhi 12.7
Capt BCD jhi 20.2
Morgan BCD xyz 17.3

I need awk to first search only those entries that have jhi, of those jhi entries, I'd like to awk find the lowest value of column 4 (in this case 12.7). Once I find that, I need to print column and column 2.

What I've figured out thus far is:

Code:

awk '$3 == "jhi" {print $4}' input_file | sort | awk 'NR == 1'

That gets me to the lowest value of column 4 (12.7), but I need to somehow go back and get column 1 (Jack) to print. Any ideas?

try:

Code:

sort -n -k4 inputfile | awk '!arr[$3]++' > outputfile

And 12.5 is the lowest not 12.7.

Code:

#awk '{ print $4" "$1 | "sort" }' myFile | head -1

12.5 Jim

If you'd like to sort it, try this:

Code:

grep jhi urfile |sort -k4rn |tail -1 |awk '{print $1}'

or by awk:

Code:

awk '
BEGIN{a=99999999}
/jhi/ {if ($NF<a) {a=$NF;b=$1}}
END{print b}
' urfile

Jack