- 论坛徽章:
- 0
|
现有file1,file2 两个文件。文件file1有2列,内容如:
no1 name1
no2 name2
no3 name2
no4 name3
no5 name4
no6 name4
no7 name4
no8 name5
no9 name6
no10 name6
文件file2 有6列,部分有空格,内容如下:
name1 data1 dada2 data3 data4 dada5
name2 dada6 data7 dada8
name3 data9 dada10 data11 dada12
name4 data13 dada14
name5 data15 dada16
name6 data17 data18
如果file1的第2列跟file2的第1列匹配,则将两条数据合并成一条,合并后的数据应该是这样的:
no1 name1 data1 dada2 data3 data4 dada5
no2 name2 dada6 data7 dada8
no3 name2 dada6 data7 dada8
no4 name3 data9 dada10 data11 dada12
no5 name4 data13 dada14
no6 name4 data13 dada14
no7 name4
no8 name5 data15 dada16
no9 name6 data17 data18
no10 name6 data17 data18
程序:
awk 'NR==FNR{a[$1]=$0}NR>FNR{print $1" "a[$2]}' file2 file1
1、请问print $1" "a[$2]这里a[$2]这是指什么意思?因为没有理解这个,我参考解决自己的问题但未遂,我的问题如下
cat a
WHBSC72,RXOTG-497
WHBSC72,RXOTG-498
WHBSC72,RXOTG-499
WHBSC72,RXOTG-500
WHBSC72,RXOTG-501
WHBSC72,RXOTG-502
WHBSC72,RXOTG-503
WHBSC72,RXOTG-504
WHBSC72,RXOTG-505
WHBSC72,RXOTG-506
WHBSC72,RXOTG-507
WHBSC72,RXOTG-508
WHBSC72,RXOTG-509
WHBSC72,RXOTG-510
cat b
WHBSC72,RXOTG-497,WH4272
result
WHBSC72,RXOTG-497,WH4272
WHBSC72,RXOTG-498
WHBSC72,RXOTG-499
WHBSC72,RXOTG-500
WHBSC72,RXOTG-501
WHBSC72,RXOTG-502
WHBSC72,RXOTG-503
WHBSC72,RXOTG-504
WHBSC72,RXOTG-505
WHBSC72,RXOTG-506
WHBSC72,RXOTG-507
WHBSC72,RXOTG-508
WHBSC72,RXOTG-509
WHBSC72,RXOTG-510
这是我模仿做的结果,但不是我想要的结果
awk ' BEGIN{OFS=FS=","}NR==FNR{ a[$1","$2]=$0}NR>FNR{print $1,$2,a[$0]}' b a
我执行的结果
WHBSC72,RXOTG-497,WHBSC72,RXOTG-497,WH4272
WHBSC72,RXOTG-498,
WHBSC72,RXOTG-499,
WHBSC72,RXOTG-500,
WHBSC72,RXOTG-501,
WHBSC72,RXOTG-502,
WHBSC72,RXOTG-503,
WHBSC72,RXOTG-504,
WHBSC72,RXOTG-505,
WHBSC72,RXOTG-506,
WHBSC72,RXOTG-507,
WHBSC72,RXOTG-508,
WHBSC72,RXOTG-509,
WHBSC72,RXOTG-510, |
|