Shell Programming and Scripting

123xyz   0    0    1    2    0    0    0    0    0    0    0     
234xyz   0    0    0    0    0    0    0    0    0    0    0    
345xyz   0    0    1    0    0    0    0    0   -9   -9   -9

123xyz   2

awk '{for(x=1;x<=NF;x++)a[++y]=$x}END{c=asort(a);print "max:",a[c]}'

awk '
BEGIN   {MAX=-1E100
        }
        {for (x=2; x<=NF; x++) if ($x>MAX)      {MAX = $x
                                                 C1  = $1
                                                }
        }
END     {print C1, MAX
        }
' file
123xyz 2

awk '{ for(x=2;x<=NF;x++) {a[++y]=$x; b[$x]=$1} } END { c=asort(a); print "max:",b[a[c]],a[c] }' file

awk '
NR==1 {MAX=$2; C1=$1}
{ for (x=2; x<=NF; x++) if ($x>MAX) { MAX=$x; C1=$1 } }
END { print C1, MAX } 
' file

USW00003812Y2016M02TMAXLE32 0    0    1    2    0    0    0    0    0    0    0

USW00003812 201602 TMAXLE32 2

{ print C1, MAX }

{ print substr(C1,1,11), substr(C1,13,4), substr(C1,18,2), substr(C1,20,8)}, MAX }

#!/bin/bash

for dir in a b c x y z
do

for file in USW*
do
awk '
BEGIN   {MAX=-1E100
        }
        {for (x=2; x<=NF; x++) if ($x>MAX)      {MAX = $x
                                                 C1  = $1
                                                }
        }
END     {print substr(C1,1,11), substr(C1,13,4), substr(C1,18,2), substr(C1,20,8), MAX
        }
' /dir/of/files/$dir/$file
done

done