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" />

現(xiàn)在需要比較兩個文件，如果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 發(fā)表于 2012-01-16 19:45
高手都On the way home。

謝謝，測試可用，不過樓下的簡單一些

dashorc

lionfun 發(fā)表于 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高手