awk 练习1

#cat lab3.data

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

上面的数据库中包含名字,电话号码和过去三个月里的捐款
1.显示所有电话号码
2.显示Dan的电话号码
3.显示Susan的名字和电话号码
4.显示所有以D开头的姓
5.显示所有以一个C或E开头的名
6.显示所有只有四个字符的名
7.显示所有区号为916的人名
8.显示Mike的捐款.显示每个值时都有以$开头.如$250$100$175
9.显示姓,其后跟一个逗号和名,如Jody,Savage
10.写一个awk的脚本,它的作用:
.显示Savage的全名和电话号码
.显示Chet的捐款
.显示所有头一个月捐款$250的人名.

1.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F: '{print $2}' lab3.data
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]
[phone]

2.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F: '/Dan/{print $2}' lab3.data
[phone]

3.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F: '/Susan/{print $1}' lab3.data
Susan Dalsass

4.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F '[ :]' '$2 ~ /^D/{print $2}' lab3.data
Dobbins
Dalsass

5.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F: '/^[CE]/{print $1}' lab3.data
Christian Dobbins
Chet Main
Elizabeth Stachelin

6.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F: '/[A-Z][a-z][a-z][a-z] /{print $1}' lab3.data
Mike Harrington
Jody Savage
John Goldenrod
Chet Main

7.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F: '$2 ~ /(916)/{print $1}' lab3.data
Guy Quigley
John Goldenrod
Elizabeth Stachelin

8.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F: '$1 ~ /Mike/{print "$"$3,"$"$4,"$"$5}' lab3.data
$250 $100 $175

9.em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -F '[ :]' '{print $1","$2}' lab3.data
Mike,Harrington
Christian,Dobbins
Susan,Dalsass
Archie,McNichol
Jody,Savage
Guy,Quigley
Dan,Savage
Nancy,McNeil
John,Goldenrod
Chet,Main
Tom,Savage
Elizabeth,Stachelin

10. em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ cat facts

/Savage/{sav[$0]=$1" "$2}
/Chet/{che[$0]=$1" "$3" "$4" "$5}
$3==250{s250[$0]=$1}
END{
for (a in sav)print sav[a]
for (a in che) print che[a]
for (a in s250) print s250[a]
}

em@em-laptop:~/Desktop/unix/chap06/Ex_6.001-6.054$ awk -f facts -F: lab3.data

Tom Savage [phone]
Jody Savage [phone]
Dan Savage [phone]
Chet Main 50 95 135
Archie McNichol
Nancy McNeil
Mike Harrington
Tom Savage
Guy Quigley
John Goldenrod
Susan Dalsass