# 拆分
awk -F '?|\t' '{print $6}' filename
# 查看指定行
awk 'NR==100' filename
# 根据指定条件查看
awk -F '&|=' '$32==1 && $30<=15' filename | wc -l
# 计算 N+
awk '{one+=1;if($1>1){two+=1}if($1>2){three+=1}if($1>3){four+=1}if($1>4){five+=1}if($1>5){six+=1}if($1>6){seven+=1}if($1>7){eight+=1}if($1>8){nine+=1}if($1>9){ten+=1}}END{print one,two,three,four,five,six,seven,eight,nine,ten}'
# 指定输出分隔符
awk -F ',' -v OFS="," '{print$1,$2,$3}' 201710_old > 201710
# 计算指定 key 的求和,平均数
awk -F ',' '{if($1=="a"){sum+=$2;num+=1}}END{print "sum=",sum,"num=",num,"avg=",sum/num}' test
# 最大值
awk -F ',' 'BEGIN {max = 0} {if ($2>max) max=$2} END {print "Max=", max}' test
# 最小值
awk -F ',' 'BEGIN {min = 99999999} {if ($2<min) min=$2} END {print "Min=", min}' test