LAB 3: awk EXERCISE

LAB 3: awk EXERCISE

(Refer to the database called lab3.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.

1. Print all the phone numbers.

2. Print Dan 's phone number.

3. Print Susan 's name and phone number.

4. Print all last names beginning with D .

5. Print all first names beginning with either a C or E .

6. Print all first names containing only four characters .

7. Print the first names of all those in the 916 area code.

8. Print Mike 's campaign contributions. Each value should be printed with a leading dollar sign; e.g., $250 $100 $175.

9. Print last names followed by a comma and the first name.

10. Write an awk script called facts that

    1. Prints full names and phone numbers for the Savages .

    2. Prints Chet 's contributions.

    3. Prints all those who contributed $250 the first month.