#!/usr/bin/ksh #sed1 remove blank lines #sed2 change 'k' into 000 (for digital unix) #tr remove ascii chars #sed4 remove some meta chars #awk main prog if [[ -f $1 ]] then CMD1="sed \-e '/^$/d' $*" else CMD1="sed \-e '/^$/d'" fi eval $CMD1 \ | sed -e '/[0-9]k/s/k/000/g' \ | sed -e '/[a-z,A-Z]/s///g' \ | sed -e 's/[-:/%<>]//g' \ | awk '{ maxfld=NF for (i=1; i <= maxfld; i++) { sum[i] += $i if( $i > max[i]) max[i] = $i if( $i < min[i]) min[i] = $i } } END { print ("Field Max Min Sum Avg") for (i=1; i <= maxfld; i++) printf ("%2d %10.2f %10.2f %10.2f %10.4f\n", \ i, max[i], min[i], sum[i], sum[i]/NR) }'