[root@junnan1 ~]# awk '$1~/Zhang/{print $2,$4}' /server/files/reg.txt|awk -F: '{print $1,$3}'
Dandan 100
Xiaoyu 90
[root@junnan1 ~]#
[root@junnan1 ~]# awk -F"[ :]" '$1~/Zhang/{print $2,$(NF-1)}' /server/files/reg.txt
Dandan 100
Xiaoyu 90
[root@junnan1 ~]#
第一题2.png
显示所有ID号码最后一位数字是1或5的人的全名
awk '/{print
2}' /server/files/reg.txt
[root@junnan1 ~]# awk '$3~/[15]$/{print $1,$2}' /server/files/reg.txt
Zhang Xiaoyu
Wu Waiwai
Wang Xiaoai
Li Youjiu
Lao Nanhai
[root@junnan1 ~]#
3.显示所有人的全名，以姓,名的格式显示，如Meng,Feixue
awk '{print 2}' /server/files/reg.txt|sed 's# #,#g'
[root@junnan1 ~]# awk '{print $1,$2}' /server/files/reg.txt|sed 's# #,#g'
Zhang,Dandan
Zhang,Xiaoyu
Meng,Feixue
Wu,Waiwai
Liu,Bingbing
Wang,Xiaoai
Zi,Gege
Li,Youjiu
Lao,Nanhai
[root@junnan1 ~]#
[root@junnan1 ~]# awk '{print $1","$2}' /server/files/reg.txt
Zhang,Dandan
Zhang,Xiaoyu
Meng,Feixue
Wu,Waiwai
Liu,Bingbing
Wang,Xiaoai
Zi,Gege
Li,Youjiu
Lao,Nanhai
[root@junnan1 ~]#
注释：双引号，里面是什么就显示什么
显示Xiaoyu的捐款.每个值时都有以520
135
awk '/Xiaoyu/{print #g'
[root@junnan1 ~]# awk '/Xiaoyu/{print $4}' /server/files/reg.txt|sed 's#:#$#g'
$155$90$201
[root@junnan1 ~]#
[root@junnan1 ~]# awk '/Xiaoyu/{print $4}' /server/files/reg.txt|tr ':' '$'
$155$90$201
[root@junnan1 ~]#
awk '2,$10}'
[root@junnan1 ~]# awk '{gsub(/:/,"$");print $0}' /server/files/reg.txt
Zhang Dandan 41117397 $250$100$175
Zhang Xiaoyu 390320151 $155$90$201
Meng Feixue 80042789 $250$60$50
Wu Waiwai 70271111 $250$80$75
Liu Bingbing 41117483 $250$100$175
Wang Xiaoai 3515064655 $50$95$135
Zi Gege 1986787350 $250$168$200
Li Youjiu 918391635 $175$75$300
Lao Nanhai 918391635 $250$100$175
[root@junnan1 ~]#
注释：分号，动作隔开。‘{gsub(/xx/,"yy")}' 单引号里面默认是双引号
$0显示整行
创建环境:
head /etc/passwd >/oldboy/passwd.txt
调换/oldboy/passwd.txt文件的第1列和最后一列的位置（不用修改文件内容）
[root@junnan1 ~]# awk -F: '{tmp=$1;$1=$NF;$NF=tmp;print $0}' /oldboy/passwd.txt
/bin/bash x 0 0 root /root root
/sbin/nologin x 1 1 bin /bin bin
/sbin/nologin x 2 2 daemon /sbin daemon
/sbin/nologin x 3 4 adm /var/adm adm
/sbin/nologin x 4 7 lp /var/spool/lpd lp
/bin/sync x 5 0 sync /sbin sync
/sbin/shutdown x 6 0 shutdown /sbin shutdown
/sbin/halt x 7 0 halt /sbin halt
/sbin/nologin x 8 12 mail /var/spool/mail mail
/sbin/nologin x 11 0 operator /root operator
[root@junnan1 ~]#
[root@junnan1 ~]# awk -F: -vOFS=":" '{tmp=$1;$1=$NF;$NF=tmp;print $0}' /oldboy/passwd.txt
/bin/bash:x:0:0:root:/root:root
/sbin/nologin:x:1:1:bin:/bin:bin
/sbin/nologin:x:2:2:daemon:/sbin:daemon
/sbin/nologin:x:3:4:adm:/var/adm:adm
/sbin/nologin:x:4:7:lp:/var/spool/lpd:lp
/bin/sync:x:5:0:sync:/sbin:sync
/sbin/shutdown:x:6:0:shutdown:/sbin:shutdown
/sbin/halt:x:7:0:halt:/sbin:halt
/sbin/nologin:x:8:12:mail:/var/spool/mail:mail
/sbin/nologin:x:11:0:operator:/root:operator
[root@junnan1 ~]#
awk替换.png
注释：-vOFS=":"，修改每一列的分隔符为冒号，-F:=-vFS=":"
-v就是修改awk的内置变量.
- 解压windows下面的zip压缩文件，unzip access.zip -d /oldboy/
- BEGIN{}和END{}的用法
[root@junnan1 ~]# awk 'BEGIN{print "name"}{print $1}' /oldboy/oldboy.txt
name
I
I
I
my
our
my
not
my
oldboy
BEGIN{}如上：
[root@junnan1 ~]# awk '{print $1}END{print "name"}' /oldboy/oldboy.txt
I
I
I
my
our
my
not
my
oldboy
name
[root@junnan1 ~]#
END{},如上：
[root@junnan1 ~]# awk 'BEGIN{print 1/3}'
0.333333
[root@junnan1 ~]# awk 'BEGIN{print 2^10}'
1024
[root@junnan1 ~]# awk 'BEGIN{print 2*10}'
20
[root@junnan1 ~]# awk 'BEGIN{print 2+10}'
12
[root@junnan1 ~]#
注释：加减乘除
- 统计文件中空行的总数
[root@junnan1 ~]# awk '/^$/{i=i+1}END{print i}' /etc/services
17
[root@junnan1 ~]#
- 统计access.log中 第9列是200的数量
[root@junnan1 ~]# awk '$9==200{i=i+1}END{print i}' /oldboy/access.log
142666
[root@junnan1 ~]#
- 1加到100，等于多少。
[root@junnan1 ~]# seq 100|awk '{i=i+$1}END{print i}'
5050
[root@junnan1 ~]#
