向awk高手請教方法，謝謝

yangbosos

有這一樣一個文件，
內(nèi)容如下：
1,act,secKill,172.24.138.91,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
2,act,secKill,172.24.138.92,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
3,act,secKill,172.24.138.93,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
4,act,secKill,172.24.138.94,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
5,act,groupbuy,172.24.138.64,9090,0,0,40670,26646,/data/postmall/tomcat/webapps_act/groupbuy,2012-12-14
6,act,groupbuy,172.24.138.123,9090,0,0,40670,26646,/data/postmall/tomcat/webapps_act/groupbuy,2012-12-14
7,act,lottery,172.24.138.64,9090,0,0,35311,18247,/data/postmall/tomcat/webapps_act/lottery,2012-12-14
8,act,lottery,172.24.138.123,9090,0,0,35311,18247,/data/postmall/tomcat/webapps_act/lottery,2012-12-14
9,act,promoeng,172.24.138.64,9090,0,0,40670,38204,/data/postmall/tomcat/webapps_act/promoeng,2012-12-14
10,act,promoeng,172.24.138.123,9090,0,0,40670,38204,/data/postmall/tomcat/webapps_act/promoeng,2012-12-14
11,dw,jreport,172.24.154.177,8080,0,0,42019,24019,/data/postmall/tomcat/webapps_birt/jreport,2012-12-20
12,bankcall,bankcall,172.24.138.45,9090,0,0,112205,65786,/data/postmall/tomcat/webapps_monitor/bankcall,2012-12-14
13,card,ROOT,172.24.138.74,8080,0,0,41611,50709,/data/postmall/tomcat/webapps_ulecard/ROOT,2012-12-14
14,card,ROOT,172.24.138.75,8080,0,0,41611,50709,/data/postmall/tomcat/webapps_ulecard/ROOT,2012-12-14
15,card,ROOT,172.24.138.182,8080,0,0,41611,50709,/data/postmall/tomcat/webapps_ulecard/ROOT,2012-12-14
16,card,ROOT,172.24.138.183,8080,0,0,41611,50709,/data/postmall/tomcat/webapps_ulecard/ROOT,2012-12-14
17,cart,ROOT,172.24.138.45,8080,0,0,40895,45550,/data/postmall/tomcat/webapps_cart/ROOT,2012-12-14
18,cart,ROOT,172.24.138.46,8080,0,0,40895,45551,/data/postmall/tomcat/webapps_cart/ROOT,2012-12-14

請問，怎么用awk實現(xiàn)，第二列相同的數(shù)行內(nèi)，第九列也相同，就打OK，否則no

1,act,secKill,172.24.138.91,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
2,act,secKill,172.24.138.92,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
3,act,secKill,172.24.138.93,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
4,act,secKill,172.24.138.94,0,0,0,34776,13366,/data/postmall/tomcat/webapps_act/secKill,2012-12-14
這四行吧，第二列相同吧，第九列也相同，然后打印OK出來

17,cart,ROOT,172.24.138.45,8080,0,0,40895,45550,/data/postmall/tomcat/webapps_cart/ROOT,2012-12-14
18,cart,ROOT,172.24.138.46,8080,0,0,40895,45551,/data/postmall/tomcat/webapps_cart/ROOT,2012-12-14
第二列相同吧，第九列不相同，然后打印no出來

blackold

回復 1# yangbosos


    第二列相同？和哪比較相同？

waker

樓主的頭像牛!形象的向我們解釋了成語:叨的一筆

Shell_HAT

樓主能否以頂樓數(shù)據(jù)為例，給出希望的結果？

yestreenstars

我希望以后發(fā)帖的人都能按這種格式發(fā)：

原文本：
XXX

要求：
XXX

目標文本：
XXX

當然這只是個人意見。

reyleon

1. awk 'BEGIN{FS=","}{a[$2","$9]=a[$2","$9]?a[$2","$9]"\n"$0:$0;b[$2","$9]++}END{for(i in b)if(b[i]>1){print "OK\n"a[i]}else{print "No "a[i]}}' urfile

復制代碼

yangbosos

回復 6# reyleon

真是高手AWK呢，這么復雜的東西，兄弟調(diào)試了幾分鐘呢。


   

yangbosos

reyleon 兄，能把這句經(jīng)典解釋一下么，謝謝

ljwd1000

1. awk 'BEGIN{FS=","}{if(a[$2,$9]){a[$2,$9]=a[$2,$9]"\n"$0}else{a[$2,$9]=$0};b[$2,$9]++}END{for(i in a)if(b[i]>1){print a[i]"\tok"}else{print a[i]"\tno"}}' file

復制代碼

回復 8# yangbosos



這樣能看懂么？