linux 字符的字符串操作命令

awk 求和,平均数,最大最小值

1.求和

 cat data|awk '{sum+=$1} END {print "SUM=" ,sum}'

2.求平均

cat data|awk '{sum+=$1} END {print  "Average=",sum/NR}'

3.求最大值

cat data|awk 'BEGIN{max = 0} {if ($1>max) max=$1 fi} END {print "Max=",max}'

4.求最小值

awk 'BEGIN {min = 19999999}{if ($1<min) min=$1 fi} END {print "Min=",min}'

5.获取子串

    awk -F ':' '{print substr($2,1,length($2)-2)}'