awk练习笔记

题目数据如下：

mike harrington:[phone]:250:100:175

christian dobbins:[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 stachelin:[phone]:175:75:300

上面这个数据库的记录内容包括姓名、电话号码和最近3个月的竞选捐款数额。
1.打印在第二个月捐款超过100美元的人的姓和名。
awk -f: '$4>100{print $1}' lab3.data
2.打印在最后一个月捐款少于85美元的人的姓名和电话号码
awk -f: '$5<85{print $1,$2}' lab3.data
3.打印第一个月捐款额在75~150美元之间的人。
awk -f: '$5>=75 && $5<=150 {print $1}' lab3.data
4.打印这3个月的捐款总额不超过800美元的人。
awk -f: '$3+$4+$5 <= 800 {print $1}' lab3.data
5.打印月均捐款额大于200美元的人的姓名和电话号码。
awk -f: '$3+$4+$5 > 600{print $1,$2}' lab3.data
6.打印不在916区的人的姓。
awk -f"[ :]" '$3 !~ "916"{print $2}' lab3.data
7.打印每条记录，并在记录前加上其记录号。
awk '{print nr,$0}' lab3.data
8.打印每个人的姓名和捐款总额。
awk -f: '{print $1,$3+$4+$5}' lab3.data
9.把chet第二个月的捐款额加上10
awk -f: '/chet/{$4=$4+10} {print $0}' lab3.data
10.把 nancy mcneil的名字改成louise mcinnes
awk -f: '/nancy mcneil/{$1="louise mclnnes"} {print}' lab3.data

 11.写出一个awk脚本输出以下信息

 

                       ***campaign 1998 contributions***
--------------------------------------------------------------------------------
name                      phone            jan  |  feb  |  mar  |  total donated
--------------------------------------------------------------------------------
mike harrington     [phone]        250.00  100.00  175.00  525.00
christian dobbins   [phone]        155.00  90.00   201.00  446.00
susan dalsass       [phone]        250.00  60.00   50.00   360.00
archie mcnichol     [phone]        250.00  100.00  175.00  525.00
jody savage         [phone]        15.00   188.00  150.00  353.00
guy quigley         [phone]        250.00  100.00  175.00  525.00
dan savage          [phone]        450.00  300.00  275.00  1025.00
nancy mcneil        [phone]        250.00  80.00   75.00   405.00
john goldenrod      [phone]        250.00  100.00  175.00  525.00
chet main           [phone]        50.00   95.00   135.00  280.00
tom savage          [phone]        250.00  168.00  200.00  618.00
elizabeth stachelin [phone]        175.00  75.00   300.00  550.00
--------------------------------------------------------------------------------
                              summary                                           
--------------------------------------------------------------------------------
the campaign received a total of $6137.00 for this quarter.
the average donation for the 12 conrtibutors was $511.42.
the highest contribution was $450.00.
the lowest contribution was $15.00.

$ cat lab3.awk 
#!/usr/bin/awk -f

begin{
    fs=":"
    print "                       ***campaign 1998 contributions***"
    print "--------------------------------------------------------------------------------"
    print "name                      phone            jan  |  feb  |  mar  |  total donated"
    print "--------------------------------------------------------------------------------"
    min=1000.0
    max=0
    total=0
}
{
    total+=$3+$4+$5
    if($3<min)
        min=$3
    if($4<min)
        min=$4
    if($5<min)
        min=$5
    if($3>max)
        max=$3
    if($4>max)
        max=$4
    if($5>max)
        max=$5
    printf "%-20s%14s        %-6.2f  %-6.2f  %-6.2f  %-6.2f\n",$1,$2,$3,$4,$5,$3+$4+$5 
}
end{
    print "--------------------------------------------------------------------------------"
    print "                              summary                                           "
    print "--------------------------------------------------------------------------------"
    printf "the campaign received a total of $%6.2f for this quarter.\n",total
    printf "the average donation for the 12 conrtibutors was $%5.2f.\n",total/12.0
    printf "the highest contribution was $%5.2f.\n",max
    printf "the lowest contribution was $%4.2f.\n",min
}