grep sed awk 過濾相同內(nèi)容
grep
[root@yuyingqian ~]# grep 'oldb.y' oldboy.txt I am oldboy teacher! my blog is http://oldboy.blog.51cto.com our size is http://blog.oldboyedu.com my god ,i am not oldbey,but OLDBOY!sed
[root@yuyingqian ~]# sed -n '/oldb.y/p' oldboy.txt I am oldboy teacher! my blog is http://oldboy.blog.51cto.com our size is http://blog.oldboyedu.com my god ,i am not oldbey,but OLDBOY!awk
[root@yuyingqian ~]# awk '/oldb.y/' oldboy.txt I am oldboy teacher! my blog is http://oldboy.blog.51cto.com our size is http://blog.oldboyedu.com my god ,i am not oldbey,but OLDBOY!
awk按列過濾
[root@yuyingqian ~]# cat /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
過濾出第二列以X開頭的行
[root@yuyingqian ~]# awk '$2~/^X/' /server/files/reg.txt Zhang Xiaoyu 390320151 :155:90:201 Wang Xiaoai 3515064655 :50:95:135
過濾出第三列以5結(jié)尾的行
[root@yuyingqian ~]# awk '$3~/5$/' /server/files/reg.txt Wang Xiaoai 3515064655 :50:95:135 Li Youjiu 918391635 :175:75:300 Lao Nanhai 918391635 :250:100:175
過濾出第三列以5結(jié)尾的行 顯示第三列跟第四列
[root@yuyingqian ~]# awk '$3~/5$/{print $3,$4}' /server/files/reg.txt 3515064655 :50:95:135 918391635 :175:75:300 918391635 :250:100:175
姓氏是Zhang的人，顯示他的第二次捐款金額及她的名字
[root@yuyingqian ~]# awk -F"[ :]+" '$1~/Zhang/{print $1,$2,$5}' /server/files/reg.txt Zhang Dandan 100 Zhang Xiaoyu 90
顯示所有ID號碼最后一位數(shù)字是1或5的人的全名
[root@yuyingqian ~]# awk '$3~/[15]$/' /server/files/reg.txt Zhang Xiaoyu 390320151 :155:90:201 Wu Waiwai 70271111 :250:80:75 Wang Xiaoai 3515064655 :50:95:135 Li Youjiu 918391635 :175:75:300 Lao Nanhai 918391635 :250:100:175
顯示所有人的全名，以姓,名的格式顯示，如Meng,Feixue
[root@yuyingqian ~]# 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
顯示Xiaoyu的捐款.每個值時都有以$開頭.如$520$200$135
[root@yuyingqian ~]# awk '{gsub(/:/,"$");print $4}' /server/files/reg.txt $250$100$175 $155$90$201 $250$60$50 $250$80$75 $250$100$175 $50$95$135 $250$168$200 $175$75$300 $250$100$175
換/oldboy/passwd.txt文件的第一列和最后一列(不用修改文件內(nèi)容)
[root@yuyingqian ~]# cat /oldboy/passwd.txt root:x:0:0:root:/root:/bin/bash bin:x:1:1:bin:/bin:/sbin/nologin [root@yuyingqian ~]# sed -r 's#(.*)(:x.*:)(.*)#\3\2\1#g' /oldboy/passwd.txt /bin/bash:x:0:0:root:/root:root /sbin/nologin:x:1:1:bin:/bin:binawk調(diào)換
[root@yuyingqian ~]# 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 binawk調(diào)換
awk顯示時以什么分割 OFS (awk的內(nèi)置變量) -v修改
[root@yuyingqian ~]# 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
BEGIN{}里面的內(nèi)容會在awk讀取文件之前運行
[root@yuyingqian ~]# awk -F: 'BEGIN{print "name"}{print $1}' /oldboy/passwd.txt name root bin運行測試
[root@yuyingqian ~]# awk 'BEGIN{print 1/5,1*5,1+5,1-5}' 0.2 5 6 -4
統(tǒng)計文件中空行的數(shù)量
[root@yuyingqian ~]# cat /oldboy/oldboy.txt oldboy dsadsa d sadsa sa dsad dsadasd [root@yuyingqian ~]# awk '/^$/{i=i+1;print i}' /oldboy/oldboy.txt 1 2 3 4 5
awk計算公式:i=i+1/i++ (i從0開始)
進行計數(shù) 計算一共出現(xiàn)了多少次
END{}里面的內(nèi)容會在awk讀取文件之后運行
[root@yuyingqian ~]# awk '/^$/{i=i+1;print i}' /oldboy/oldboy.txt 1 2 3 4 5 [root@yuyingqian ~]# awk '/^$/{i=i+1}END{print i}' /oldboy/oldboy.txt 5
統(tǒng)計access.log中 第九列是200的數(shù)量
[root@yuyingqian ~]# awk '$9==200{i++}END{print i}' access.log 142666 [root@yuyingqian ~]# awk '$9~/^200$/{i++}END{print i}' access.log 142666
i+i+$1數(shù)字(求和/累加) i從0開始 $依次+1
[root@yuyingqian ~]# seq 100 |awk '{i=i+$1}END{print i}' 5050
