LAB 6: nawk EXERCISE

LAB 6: nawk EXERCISE

(Refer to the database called lab6.data on the CD.)

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

The database above contains the names , phone numbers , and money contributions to the party campaign for the past three months.

1. Write a nawk script that will produce the following report:

    ***FIRST QUARTERLY REPORT***                     ***CAMPAIGN 2004 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 37.00 for this quarter. The average donation for the 12 contributors was 1.42. The highest total contribution was 25.00 made by Dan Savage.                       ***THANKS Dan*** The following people donated over 0 to the campaign. They are eligible for the quarterly drawing!! Listed are their names (sorted by last names) and phone numbers:    John Goldenrod--[phone]    Mike Harrington--[phone]    Archie McNichol--[phone]    Guy Quigley--[phone]    Dan Savage--[phone]    Tom Savage--[phone]    Elizabeth Stachelin--[phone]       Thanks to all of you for your continued support!!