Shell Programming and Scripting

# search only some lines
awk -v searchfld=3  -v searchvalue="Fre" -v minfld=5  -v keyfld=4 '
   BEGIN {
             minvalue=9999999999999999
         }
   ( $minfld < minvalue ) && ( $searchfld == searchvalue ) {
                        minkey=$keyfld
                        minvalue=$minfld
                      }
END {
        print "minkey:",minkey," minvalue:",minvalue
    } '  inputfile

awk -v keyfld=3  -v minfld=5  '
   BEGIN {
             minvalue=9999999999999999
         }
   Min[$keyfld]<1 { Min[$keyfld]=minvalue  }
   $minfld < Min[$keyfld]  {
                      lines[$keyfld]=$0
                      Min[$keyfld]=$minfld
                      }
END {
        for (id in lines) {
                print lines[id]
                }
    } ' inputfile

awk ' NR>1 {if(arr[$3]=="") arr[$3]=$5; if(arr[$3] >= $5) { arr[$3]=$5; sarr[$3]=$0; }} END { for (i in sarr) { print sarr[i];  } }'  filename

# max value of some fld
awk -v fld=5  '
   BEGIN {
             value=-9999999999999999
         }
   $fld > value {
                    line=$0
                    value=$fld
                    }
END {
        print line
    } '  inputfile

awk 'NR > 1 && $NF > a{a=$NF;line=$0}END{print line}' file