求助大神：查找A文件的列在B文件中，并且打印出B文件中的列

lhpedward

a文件
13908488   qer
15017368   jbc

b文件
2016/03/02 INFO Server 445643 Code 15017368   34949  =92  CHECK_SUCCESS
2016/03/01 INFO Server 424509 Code 15982986   33284 =796 CHECK_SUCCESS
2016/03/01 INFO Server 424509 Code 15116406   21821 =530 CHECK_SUCCESS
2016/03/01 INFO Server 424512 Code 13908488   33284 =37   CHECK_SUCCESS

要a的$1和b的$6对比，如果相等的话就输出b的$6、$8、$9
输出结果是
13908488  =37   CHECK_SUCCESS
15017368  =92   CHECK_SUCCESS

moperyblue

1. awk 'NR==FNR{a[$1]=1;next}a[$6]{print $6,$8,$9}' a b

复制代码

lhpedward

回复 2# moperyblue

大神，能解释一下吗？！


   

jason680

回复 1# lhpedward

>> a的$1和b的$6对比,...就输出b的$6、$8、$9


$ awk 'FNR==NR{a[$1]=1;next}a[$6]{print $6,$8,$9}' a b
15017368 =92 CHECK_SUCCESS
13908488 =37 CHECK_SUCCESS

   

jason680

回复 3# lhpedward


http://bbs.chinaunix.net/thread-2309494-1-1.html
   

sunzhiguolu

awk 处理字段真是利器啊!

lhpedward

jcdiy0601

awk 'NR==FNR{a[$1]=1;next}NR>FNR{if(a[$6])print $6,$8,$9}' a b

#!/bin/bash

while read line
do
  num=`echo $line|awk '{print $1}'`
  awk '{if($6=="'$num'")print $6,$8,$9}' b
done < a

fh21_xuejinlian

awk 'NR==FNR{a[$1];next}{if($6 in a) print $6,$8,$9}' a b | sort -k1 -n

zy86416779

1. [root@study study]# cat test.1
   
2. 13908488   qer
   
3. 15017368   jbc
   
4. [root@study study]# cat test.2
   
5. 2016/03/02 INFO Server 445643 Code 15017368   34949  =92  CHECK_SUCCESS
   
6. 2016/03/01 INFO Server 424509 Code 15982986   33284 =796 CHECK_SUCCESS
   
7. 2016/03/01 INFO Server 424509 Code 15116406   21821 =530 CHECK_SUCCESS
   
8. 2016/03/01 INFO Server 424512 Code 13908488   33284 =37   CHECK_SUCCESS
   
9. [root@study study]# awk '{printf $1 "\n"}' test.1 > test.3
   
10. [root@study study]# sh  test.sh   
    
11. 13908488 =37 CHECK_SUCCESS
    
12. 15017368 =92 CHECK_SUCCESS
    
13. #!/bin/sh
    
14. for i in `cat test.3`
    
15. do
    
16.   awk 'Num==$6{printf $6 " " $8 " " $9 "\n"}' Num=$i test.2
    
17. done

复制代码