向awk高手请教方法，谢谢

yangbosos

有这一样一个文件，
内容如下：
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实现，第二列相同的数行内，第九列也相同，就打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

楼主能否以顶楼数据为例，给出希望的结果？

yestreenstars

我希望以后发帖的人都能按这种格式发：

原文本：
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呢，这么复杂的东西，兄弟调试了几分钟呢。


   

yangbosos

reyleon 兄，能把这句经典解释一下么，谢谢

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



这样能看懂么？