awk 练习3

$ cat -A lab5.data1
Mike Harrington:[phone]:250:100:175
Christian Dobbi:[phone]:155:90:201
Susan Dalsass:[phone]:250:60:50
Archie McNichol:[phone]:250:100:175
Jody Savage:[phone]:15:188:150
Guy Quigley:[phone]:250:100:175
Dan Savage:[phone]:450:300:275
Nancy McNeil:[phone]:250:80:75
John Goldenrod:[phone]:250:100:175
Chet Main:[phone]:50:95:135
Tom Savage:[phone]:250:168:200
Elizabeth Stach:[phone]:175:75:300

要求写脚本达到以下效果：

        ***CAMPAIGN 1998 CONTRIBUTIONS***
________________________________________________________________________

NAME                         PHONE                   Jan  | Feb  | Mar  | Total Donated
________________________________________________________________________
Mike Harrington        [phone]    250   100     175        525
Christian Dobbi         [phone]    155   90       201        446
Susan Dalsass          [phone]    250   60       50          360
Archie McNichol        [phone]    250   100    175        525
Jody Savage              [phone]    15      188    150        353
Guy Quigley               [phone]     250   100    175        525
Dan Savage               [phone]     450   300    275        1025
Nancy McNeil            [phone]     250   80       75          405
John Goldenrod        [phone]     250   100     175        525
Chet Main                   [phone]     50     95        135        280
Tom Savage               [phone]     250  168      200        618
Elizabeth Stach          [phone]     175  75        300        550
_________________________________________________________________________

            SUMMARY
_________________________________________________________________________
The campaign received a total of $6137.00 for this quarter.
The average donation for the 12 contributors was $511.42.
highest contribution was $300.00
The lowest contribution was $15.00

$ awk -f awk.sc lab5.data1

                 ***CAMPAIGN 1998 CONTRIBUTIONS***
_________________________________________________________________
NAME            PHONE           JAN  |  FEB |  MAR | Total Donated
_________________________________________________________________
Mike Harrington [phone]  250     100     175     525
Christian Dobbi [phone]  155     90      201     446
Susan Dalsass   [phone]  250     60      50      360
Archie McNichol [phone]  250     100     175     525
Jody Savage     [phone]  15      188     150     353
Guy Quigley     [phone]  250     100     175     525
Dan Savage      [phone]  450     300     275     1025
Nancy McNeil    [phone]  250     80      75      405
John Goldenrod  [phone]  250     100     175     525
Chet Main       [phone]  50      95      135     280
Tom Savage      [phone]  250     168     200     618
Elizabeth Stach [phone]  175     75      300     550
_________________________________________________________________
                SUMARY
_________________________________________________________________
The campaign received a total of $6137.00 for this quarter.
The average donation for the 12 contributors was $511.42.
The highest contribution was $300
The lowest contribution was $15

这是我的代码：

$ cat awk.sc

BEGIN{FS=":"
print "\n"
print "\t\t ***CAMPAIGN 1998 CONTRIBUTIONS***"
print "_________________________________________________________________"
print "NAME\t\tPHONE\t\tJAN | FEB | MAR | Total Donated"
print "_________________________________________________________________"
highest = 0
lowest = 10000
}
{$6 = $3+$4+$5;print $1"\t"$2"\t"$3"\t"$4"\t"$5"\t"$6}
{total+=$6;average=total/12}
{if($5 > highest) highest = $5;}
{if($3 < lowest) lowest = $3;}
END{
print "_________________________________________________________________"
print "\t\tSUMARY"
print "_________________________________________________________________"
printf "The campaign received a total of $" "%2.2f\n",total" for this quarter."
printf "The average donation for the 12 contributors was $" "%2.2f\n",average"."
print "The highest contribution was $"highest
print "The lowest contribution was $"lowest
}