awk处理两个文件的问题

dashorc

cat file1:

9 1     28234   131072
9 0     28298   131072
25 0    28362   131072
20 0    28426   131072
10 0    28490   131072
2 0     28554   131072
3 0     28618   131072
5 0     28682   131072

cat file2:

<!-- Name:0x25 -->
<forward cmd="0x25" sub_cmd="any" l5_mod_id="25" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<!-- Name:0x09 r -->
<forward cmd="0x09" sub_cmd="0x00" l5_mod_id="9" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<forward cmd="0x09" sub_cmd="0x02" l5_mod_id="9" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<forward cmd="0x09" sub_cmd="0x03" l5_mod_id="9" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<!-- Name:0x09 w -->
<forward cmd="0x09" sub_cmd="0x01" l5_mod_id="9" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />
<forward cmd="0x09" sub_cmd="0x04" l5_mod_id="9" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />

现在需要比较两个文件，如果file2里面的l5_mod_id 和l5_cmd_id和file1里面的第一列和第二列的值相等，那么将l5_mod_id后面的值替换成file1文件的第三列值。

最终想要的文件应该为：

<!-- Name:0x25 -->
<forward cmd="0x25" sub_cmd="any" l5_mod_id=" 28362" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<!-- Name:0x09 r -->
<forward cmd="0x09" sub_cmd="0x00" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<forward cmd="0x09" sub_cmd="0x02" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<forward cmd="0x09" sub_cmd="0x03" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
<!-- Name:0x09 w -->
<forward cmd="0x09" sub_cmd="0x01" l5_mod_id="28234" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />
<forward cmd="0x09" sub_cmd="0x04" l5_mod_id="28234" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />


自己写了一个，但是得不出来结果
awk 'BEGIN{FS="[\" \t]"}NR==FNR{a[$1]=$1"X"$2;b[$1]=$3}NR>FNR{c=$9"X"$12;if(c=a[$9]) $9=b[$6]}' file1 file2

但是awk 'BEGIN{FS="[\" \t]"}NR==FNR{a[$1]=$1"X"$2;b[$1]=$3}NR>FNR{c=$9"X"$12;if(c=a[$9]) $9="1111";print}' file1 file2
这个是可以打印出来
为什么我的b[$1]=$3取不到值？

dashorc

过年放假，求高手指点啊，每次手工改文件很恶心

lionfun

回复 1# dashorc

我也来试一个一般般的

1. [root@local ~]# awk 'NR==FNR{a[$1$2]="l5_mod_id=\""$3"\"";next}NR>FNR && /forward/{t=$5;gsub(/l5_mod_id=|"/,"",$4);gsub(/l5_cmd_id=|"/,"",$5);$4=a[$4$5];$5=t}1' file1.txt file2.txt
   
2. 
   
3. <!-- Name:0x25 -->
   
4. <forward cmd="0x25" sub_cmd="any" l5_mod_id="28362" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
5. <!-- Name:0x09 r -->
   
6. <forward cmd="0x09" sub_cmd="0x00" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
7. <forward cmd="0x09" sub_cmd="0x02" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
8. <forward cmd="0x09" sub_cmd="0x03" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
9. <!-- Name:0x09 w -->
   
10. <forward cmd="0x09" sub_cmd="0x01" l5_mod_id="28234" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />
    
11. <forward cmd="0x09" sub_cmd="0x04" l5_mod_id="28234" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />

复制代码

dashorc

zooyo 发表于 2012-01-16 19:45
高手都On the way home。

谢谢，测试可用，不过楼下的简单一些

dashorc

lionfun 发表于 2012-01-16 19:51
回复 1# dashorc

我也来试一个一般般的

代码好用，原来我一直在钻牛角尖，看了您的代码恍然大悟哈

jiejie455

awk 'NR==FNR{a["l5_mod_id=\""$1"\" l5_cmd_id=\""$2"\""]="l5_mod_id=\""$3"\" l5_cmd_id=\""$2"\""}NR>FNR{for(i in a){gsub(i,a,$0)};print $0}' file1 file2

xxhacker

牛人啊，学习学习了

yangkyo821

1. [joe@joe-laptop test]$ awk 'NR==FNR{a[$1,$2]=$3;next}{FS="\"";OFS="\"";if(($6,$8) in a)$6=a[$6,$8]}1' 1 2
   
2. <!-- Name:0x25 -->
   
3. <forward cmd="0x25" sub_cmd="any" l5_mod_id="28362" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
4. <!-- Name:0x09 r -->
   
5. <forward cmd="0x09" sub_cmd="0x00" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
6. <forward cmd="0x09" sub_cmd="0x02" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
7. <forward cmd="0x09" sub_cmd="0x03" l5_mod_id="28298" l5_cmd_id="0" protocol="udp" conn_pool_size="1" />
   
8. <!-- Name:0x09 w -->
   
9. <forward cmd="0x09" sub_cmd="0x01" l5_mod_id="28234" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />
   
10. <forward cmd="0x09" sub_cmd="0x04" l5_mod_id="28234" l5_cmd_id="1" protocol="udp" conn_pool_size="1" />
    

复制代码

lastfile

围观各路shell高手