linux awk高级脚本,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)?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

{low2=(low1

{low3=(low1

{min12=(low1

{min23=(low2

{Min=(min12

END{

print "-----------------------------------------------------------------------------------"

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 "."

}