文件匹配合并问题 有点难度

nakalzz

各位高手今天工作中遇到一个处理文件的难题
还请多多指教

如下
a.txt
12,434,ok
23,434,ok
334,443,ng
32,215,ok
44,453,ok

b.txt
12,434,ok
334,443,ng
44,453,ng
55,232,ok

现在想把a.txt和b.txt合并为
c.txt
12,434,ok 12,434,ok
23,434,ok,xx,xx,xx
334,443,ng 334,443,ng
32,215,ok,xx,xx,xx
44,453,ok 44,453,ng
xx,xx,xx 55,232,ok

这里的匹配是以前两个field来决定的
比如说44,453,ok和44,453,ng也算平配成功
如果不匹配成功就默认为xx,xx,xx

还请多多指教

yinyuemi

回复 1# nakalzz


    c.txt
12,434,ok 12,434,ok
23,434,ok
334,443,ng 334,443,ng
32,215,ok 32,215,ok # 这个从哪来的？

nakalzz

回复 2# yinyuemi


  谢谢确认 这里写错了
  因该是没有匹配
  问题修改了 还请多多指教

kk5234

回复 1# nakalzz

awk 'NR==FNR{a[$0]=$0;next}{print $0,a[$0]}' b.txt a.txt
   

nakalzz

回复 4# kk5234


    你好 题目有些变化 还请多多指教

kk5234

回复 5# nakalzz

你的题目不会再变了吧

awk -F, 'ARGIND==1{a[$1$2]=$0}ARGIND==2{b[$1$2]=$0;if($1$2 in a)print $0,a[$1$2];else print $0,"xx,xx,xx,"}ARGIND==3{if(!($1$2 in b))print "xx,xx,xx",$0}' b.txt a.txt b.txt
12,434,ok 12,434,ok
23,434,ok xx,xx,xx,
334,443,ng 334,443,ng
32,215,ok xx,xx,xx,
44,453,ok 44,453,ng
xx,xx,xx 55,232,ok

blackold

try:

1. awk -F, 'NR==FNR{a[$1"_"$2]=$0;next}{k=$1"_"$2;if(k in a){ print a[k],$0;delete a[k]}else print "xx,xx,xx,"$0}END{for(i in a) print a[i]",xx,xx,xx"}' file1 file2

复制代码

1. join -t, -a 1 -a 2 -o 0,1.2,0,2.2 -e xx <(sed 's/,/#/' file1|sort) <(sed 's/,/#/' file2|sort)|sed 's/#/,/g'|sed 's/[^,]\+,[^,]\+,xx/xx,xx,xx/g'

复制代码

yinyuemi

回复 6# kk5234



    a[$1$2], this could be risky, since "12,345,ok" "123,45,ok" would have the same key as '12345'.

yumiao5642

强大的AWK.....努力中!!!

yun_88

AWK  好强大