awk 'BEGIN{print "name" "\t" "worker" "\t" "money"} {split($3,date,"-");if(date[2]=="01"){salar[$1]=$5+salar[$1];if($2=="0"){ww[$1]="manager"}else{ww[$1]="worker"}}} END{for(i in salar){print i "\t" ww[i] "\t" salar[i] "\t"}}' awk.txt
数据:
Tom 0 2012-12-11 car 3000
John 1 2013-01-13 bike 1000 v
ivi 1 2013-01-18 car 2800
Tom 0 2013-01-20 car 2500
John 1 2013-01-28 bike 3500