環境
RedHat Linux 9 + VWWare 8.0 + SSH 3.2.9
任務
下面的文本中包含名字、電話和為黨派運動捐款的數額。
名字:電話:1月捐款情況:2月捐款情況:3月捐款情況
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
NancyMcNeil:(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
使用你能用到的任何linux命令腳本產生一個如下的報告，注意，報告中的summery包含對於捐款情況的一些統計信息。
解決
awk -F ":" 'BEGIN{
print " ***FIRST QUARTERLY REPORT **** \n";
print " ***CAMPAIGN 2000 CONTRIBUTIONS ***\n";
print "-------------------------------------------------------------------\n";
print " NAME PHONE JAN| Feb| Mar| Total Danated \n";
print "-------------------------------------------------------------------\n";
}
BEGIN{sum=0;total=0;average=0;i=0;highest=0;name;biaozhun=500;firstNames[12];count=0;lastNames[12];person[12]}
{for(i=0;i<NR;i++){person[i]=$1}}
{total=$3+$4+$5;sum+=total;average=sum/12;}
{if(total>highest) highest=total;if(highest == total)name=$1;}
{if(total>biaozhun){firstNames[count]=$1;lastNames[count]=$2;count++;}}
{printf("%-20s%12s%5d%5d%5d\t%5d\n",$1,$2,$3,$4,$5,total);}
END{
print "-------------------------------------------------------------------\n";
print " SUMMARY \n";
print "-------------------------------------------------------------------\n";
printf("The campaign received a total of $%d for this quartor\n",sum);
printf("The average donation for the %d contributors was $%.2f.\n",NR,average);
printf("The highest total contribution was $%.2f made by %s\n",highest,name);
printf(" ***THANKS Dan*** \n");
printf("The following people donated over \$500 to the campaign \n");
printf("They are eligible for the quarterly drawing!! \n");
printf("Listed are their names (sorted by last names) and phone numbers: \n");
{OFS="--";$1="\t"$1;}
for(i=0;i<count;i++) {print firstNames[i],lastNames[i] | "sort -k 2"};
printf(" Thanks to all of you for your continued support!! \n");
}
' salary.txt
運行效果截圖
參考資料
AWK使用練習 http://www.linuxidc.com/Linux/2012-11/74817.htm
問題提出
這句話（Thanks to all of you for your continued support!! ）打印在for之前，for裡面有變量就會出現這種情況，for裡面只打印純文本的話就不會出現這個情況。求解釋。
