求助：awk的写法！

sundful

有两个文件，分别是文件A和文件B,格式如下：
A:

1. 13811111111
   
2. 13911111111
   
3. 15011111111
   
4. 13822222222
   
5. 13922222222
   
6. 15022222222

复制代码

B:

1. 211.138.100.173 - - 2011-09-01 00:00:36 "GET /space/friendspace/layout.action?friendUserId=166467966&tp=space HTTP/1.0" 200 8497 "-"
   
2. "10.214.56.178" "SonyEricssonK700c/R2AE SEMC-Browser/4.0.3 Profile/MIDP-2.0 Configuration/CLDC-1.1" "-" "8615011111111" "HTTP/1.1 S
   
3. XTY-PS-WAP-GW11 (infoX-WISG, Huawei Technologies)" "-"
   
4. 218.202.106.201 - - 2011-09-01 00:00:36 "GET /im/chat/toinputMsg.action?touserid=707610079&backUrl=&t=42969748415091570&tp=space HTT
   
5. P/1.1" 200 7325 "-" "10.162.219.141" "Maui Browser" "-" "8613811111111" "ZXWAP GateWay,ZTE Technologies" "-"
   
6. 211.137.199.53 - - 2011-09-01 00:00:36 "POST /im/chat/sendMsg.action?touserid=653598235&tp=space HTTP/1.0" 200 1421 "-" "10.152.41.2
   
7. 47" "MX8/1.00 Nucleus RTOS/V1.11.19 MTK6225/07B Release/04.25.2008 Browser/Teleca Profile/MIDP-2.0 Configuration/CLDC-1.0" "-" "8615
   
8. 022222222" "HTTP/1.1 SDJN-PS-WAP2-GW16 (infoX-WISG, Huawei Technologies)" "-"
   
9. 211.136.115.45 - - 2011-09-01 00:00:36 "GET /space/giftbags/applystep2.action HTTP/1.0" 200 969 "-" "10.142.172.97" "MOT-A3000_CMCC/
   
10. 1.0 Release/09.09.2008 Profile/MIDP-2.0 Configuration/CLDC-1.1 Software/WM6.1 (compatible; MSIE 6.0; Windows CE; IEMobile 7.11)" "-"
    
11. "8613822222222" "HTTP/1.1 SHSH-PS-WAP2-GW19 (infoX-WISG, Huawei Technologies)" "-"
    

复制代码

现在想通过A的手机号，去匹配B文件里的手机号，如果B文件里包含了这个手机号，则输出手机的ua(user agent)，想写个awk，传入两个参数,如：./mytj.sh a.txt b.txt
然后把手机对应的user agent 输出到另外一个文件中：
结果如下：

1. 13811111111 Maui Browser
   
2. 15011111111 SonyEricssonK700c/R2AE SEMC-Browser/4.0.3 Profile/MIDP-2.0 Configuration/CLDC-1.1
   
3. 15022222222 MX8/1.00 Nucleus RTOS/V1.11.19 MTK6225/07B Release/04.25.2008 Browser/Teleca Profile/MIDP-2.0 Configuration/CLDC-1.0
   
4. 13822222222 MOT-A3000_CMCC/
   
5. 1.0 Release/09.09.2008 Profile/MIDP-2.0 Configuration/CLDC-1.1 Software/WM6.1 (compatible; MSIE 6.0; Windows CE; IEMobile 7.11)

复制代码

麻烦大侠帮我看看！·

ziyunfei

1. awk -F'" "' '{if(NR==FNR){a[86$0]}else{if($5 in a){print substr($5,3),$3}}}' $1 $2

复制代码

rdcwayx

1. 211.138.100.173 - - 2011-09-01 00:00:36 "GET /space/friendspace/layout.action?friendUserId=166467966&tp=space HTTP/1.0" 200 8497 "-""10.214.56.178" "SonyEricssonK700c/R2AE SEMC-Browser/4.0.3 Profile/MIDP-2.0 Configuration/CLDC-1.1" "-" "8615011111111" "HTTP/1.1 SXTY-PS-WAP-GW11 (infoX-WISG, Huawei Technologies)" "-"
   
2. 218.202.106.201 - - 2011-09-01 00:00:36 "GET /im/chat/toinputMsg.action?touserid=707610079&backUrl=&t=42969748415091570&tp=space HTTP/1.1" 200 7325 "-" "10.162.219.141" "Maui Browser" "-" "8613811111111" "ZXWAP GateWay,ZTE Technologies" "-"
   
3. 211.137.199.53 - - 2011-09-01 00:00:36 "POST /im/chat/sendMsg.action?touserid=653598235&tp=space HTTP/1.0" 200 1421 "-" "10.152.41.247" "MX8/1.00 Nucleus RTOS/V1.11.19 MTK6225/07B Release/04.25.2008 Browser/Teleca Profile/MIDP-2.0 Configuration/CLDC-1.0" "-" "8615022222222" "HTTP/1.1 SDJN-PS-WAP2-GW16 (infoX-WISG, Huawei Technologies)" "-"
   
4. 211.136.115.45 - - 2011-09-01 00:00:36 "GET /space/giftbags/applystep2.action HTTP/1.0" 200 969 "-" "10.142.172.97" "MOT-A3000_CMCC/1.0 Release/09.09.2008 Profile/MIDP-2.0 Configuration/CLDC-1.1 Software/WM6.1 (compatible; MSIE 6.0; Windows CE; IEMobile 7.11)" "-""8613822222222" "HTTP/1.1 SHSH-PS-WAP2-GW19 (infoX-WISG, Huawei Technologies)" "-"

复制代码

1. awk -F \" 'NR==FNR{a[86 $1];next} $12 in a {print $12,$8}' $1 $2

复制代码

sundful

求解释！~！~

sundful

回复 3# rdcwayx
用了下您的awk，发现不能输出东西呀！~！·求解释！~谢谢！~

rdcwayx

看看这个命令有没有输出？没有的话，自己调整。

1. awk -F \" '{print $12,$8}' b.txt

复制代码

sundful

回复 6# rdcwayx

ok，非常感谢，调试过了！！~~！·

anran_008

这样也可以

1. #!/bin/bash
   
2. 
   
3. LINE1="$1"
   
4. LINE2="$2"
   
5. 
   
6. for i in `cat ${LINE1}`
   
7. do
   
8. UA=`awk -F[\"] '/'${i}'/{print $8}' ${LINE2} `
   
9. if [[ -n ${UA} ]];then
   
10. echo ${i} ${UA}
    
11. fi
    
12. done

复制代码

fangtong2008

回复 3# rdcwayx


    这条语句next是多余的吧？

rdcwayx

回复  rdcwayx


    这条语句next是多余的吧？
fangtong2008 发表于 2011-10-18 16:10

不多余, 你再考虑一下有什么用处.