LAB 5: nawk EXERCISE

LAB 5: nawk EXERCISE

(Refer to the database called lab5.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 contains the names , phone numbers , and money contributions to the party campaign for the past three months.

Write a nawk script to produce the following output:

 %  nawk -f nawk.sc db  ***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    68.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 contribution was 0.00. The lowest contribution was .00.