请教各位一个比较麻烦的文本处理哈，2个文件第一列相同然后打印file1和file2的某列。

djzhangxing

1. cat file1
   
2. 10.0.86.10        proxy 10.0.86.1
   
3. 10.0.86.11        proxy 10.0.86.1
   
4. 10.0.86.12        proxy 10.0.86.1
   
5. 10.0.86.13        proxy 10.0.86.1
   
6. 
   
7. cat file2
   
8. 10.0.86.13  gateway 10.0.86.254
   
9. 10.0.86.12  gateway 10.0.86.1
   
10. 10.0.86.11  gateway 10.0.86.1

复制代码

想要的结果
file1中第一列IP如果能匹配到file2，就打印file1$0和file2的$2,$3,若没有就为NULL

1. 10.0.86.10        proxy 10.0.86.1                null
   
2. 10.0.86.11        proxy 10.0.86.1                gateway 10.0.86.1
   
3. 10.0.86.12        proxy 10.0.86.1                gateway 10.0.86.1
   
4. 10.0.86.13        proxy 10.0.86.1                gateway 10.0.86.254

复制代码

两个文件第一列排序是混乱的，怎么能完成以上的结果呢，好难~~求助！

yestreenstars

跟这个类似：http://bbs.chinaunix.net/forum.p ... mp;fromuid=26669282

huang6894

关联数组咯~

这个冬天不冷

1. [root@localhost ~]# awk 'NR==FNR{a[$1]=$0;next;}{if($1 in a)print a[$1],"\t",$2,$3; a[$1]="deleted"}END{for(i in a)if(a[i]!="deleted")print a[i],"\tnull"}' file1 file2
   
2. 10.0.86.13        proxy 10.0.86.1        gateway 10.0.86.254
   
3. 10.0.86.12        proxy 10.0.86.1        gateway 10.0.86.1
   
4. 10.0.86.11        proxy 10.0.86.1        gateway 10.0.86.1
   
5. 10.0.86.10        proxy 10.0.86.1       null
   
6. [root@localhost ~]# head file1 file2
   
7. ==> file1 <==
   
8. 10.0.86.10        proxy 10.0.86.1
   
9. 10.0.86.11        proxy 10.0.86.1
   
10. 10.0.86.12        proxy 10.0.86.1
    
11. 10.0.86.13        proxy 10.0.86.1
    
12. 
    
13. ==> file2 <==
    
14. 10.0.86.13  gateway 10.0.86.254
    
15. 10.0.86.12  gateway 10.0.86.1
    
16. 10.0.86.11  gateway 10.0.86.1
    

复制代码

如果不符合要求，请忽略

bulletmarquis

1. awk 'NR==FNR{a[$1]=$2" "$3;next}a[$1]{print $0,a[$1];next}{print $0,"null"}' file2 file1
   
2. 
   
3. 10.0.86.10        proxy 10.0.86.1 null
   
4. 10.0.86.11        proxy 10.0.86.1 gateway 10.0.86.1
   
5. 10.0.86.12        proxy 10.0.86.1 gateway 10.0.86.1
   
6. 10.0.86.13        proxy 10.0.86.1 gateway 10.0.86.254

复制代码