linux awk高级应用实例_linux shell_

今天看到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)?high1:$3} {high2=(high1>$4)?high1:$4} {high3=(high1>$5)?high1:$5} {max12=(high1>high2)?high1:high2} {max23=(high2>high3)?high2:high3} {Max=(max12>max23)?max12:max23} {low1=(low1<$3)?low1:$3} {low2=(low1<$4)?low1:$4} {low3=(low1<$5)?low1:$5} {min12=(low1

提示： 本文由神整理自网络，如有侵权请联系本站删除！
本站声明：
1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持；
2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！