linux awk高级应用实例
今天看到unix shell 范例精解上有道awk的题目 做了以后拿来和大家分享下
处理前的文档:
Mike Harrington:(510) 548-1278:250:100:175
Christian Dobbins:(408) 538-2358:155:90:201
Susan Dalsass:(206) 654-6279:250:60:50
Archie McNichol:(206) 548-1348:250:100:175
Jody Savage:(206) 548-1278:15:188:150
Guy Quigley:(916) 343-6410:250:100:175
Dan Savage:(406) 298-7744:450:300:275
Nancy McNeil:(206) 548-1278:250:80:75
John Goldenrod:(916) 348-4278:250:100:175
Chet Main:(510) 548-5258:50:95:135
Tom Savage:(408) 926-3456:250:168:200
Elizabeth Stachelin:(916) 440-1763:175:75:300
需要的结果如下:
***CAMPAIGN 1998 CONTRIBUTIONS***
Name PHone Jan | Feb | MAR | Total Donated
---------------------------------------------------------------------------------
Mike Harrington (510) 548-1278 250 100 175 525
Christian Dobbs (408) 538-2358 155 90 201 446
Susan Dalsass (206) 654-6279 250 60 50 360
Archie McNichol (206) 548-1348 250 100 175 525
Jody Savage (206) 548-1278 15 188 150 353
Guy Quigley (916) 343-6410 250 100 175 525
Dan Savage (406) 298-7744 450 300 275 1025
Nancy McNeil (206) 548-1278 250 80 75 405
John Goldenrod (916) 348-4278 250 100 175 525
Chet Main (510) 548-5258 50 95 135 280
Tom Savage (408) 926-3456 250 168 200 618
Elibeth Stachel (916) 440-1763 175 75 300 550
SUMMARY
-----------------------------------------------------------------------------------
The campan received atotal of $6137 for this quarter
average donation for the 12 contributors was $511.417.
The highest contribution was $450.
The lowest contribution was $15.
代码如下:
BEGIN{FS=":";low1=300;low2=400;low3=500 OFS="\t" print "\t\t***CAMPAIGN 1998 CONTRIBUTIONS***\n" print "---------------------------------------------------------------------------------\n" print " Name\t\t\tPHone\t\t\tJan |\tFeb |\tMAR |\tTotal Donated" print "---------------------------------------------------------------------------------\n" } {tot=$3+$4+$5} {Ttot+=tot} {print $1,"\t"$2"\t\t"$3" \t"$4" \t"$5" \t"tot} {avg=Ttot/12} {high1=(high1>$3)"-----------------------------------------------------------------------------------" print"\t\tSUMMARY" print "-----------------------------------------------------------------------------------" printf "The campan received atotal of $";printf Ttot; print " for this quarter" printf "average donation for the 12 contributors was $"; printf avg ;print"." printf "The highest contribution was $";printf Max;print "." printf "The lowest contribution was $";printf Min;print "." }
下一篇:linux shell实现判断输入的数字是否为合理的浮点数