重新描述一下问题~~

elu_ligao

1. grep -vf file1 file2 > file2.out
   
2. grep -vf file2 file1 > file1.out

复制代码

elu_ligao

需求是这样的
首先第一列是matchkey，如果file1中的matchkey以及对应的金额和file2中的matchkey以及对应的接相等，就移除掉这些记录

jason680

回复 3# cwd0204

结果与所述不同...

$ awk -F, 'NR==FNR{s[$1]=s[$1]?s[$1]"\n"$0:$0;a[$1]+=$2;next}{b[$1]+=$2}END{for(n in a)if(a[n]!=b[n]"")print s[n]}'  file1 file2
11902110887456,-19.45
11902110884708,-33
11902110884708,-34
11902110885021,-156
11902110884072,-440.1
11902110883499,-31
1118533453099,-899
1118533453099,-165.67
1118533453099,899
1118533453099,165.67
11902110884847,-47

$ awk -F, 'NR==FNR{s[$1]=s[$1]?s[$1]"\n"$0:$0;a[$1]+=$2;next}{b[$1]+=$2}END{for(n in a)if(a[n]!=b[n]"")print s[n]}'   file2 file1
10111880003537,129
10111880003530,38.45
10111880003512,38.45
10111880003531,38.45
10111880003513,157
10111880003504,193.8
10111880003514,105
10111880003505,219
10111880003525,35.95
1118533453099,1064.67
1118533453099,-899
1118533453099,-165.67
10111880003526,33.45

   

jason680

回复 8# cwd0204

>>已描述为准哈

描述 好像也不对......完善你的提问先...
   
不相同也被删除？
1118533453099,-899
1118533453099,-165.67
1118533453099,899
1118533453099,165.67

1118533453099,1064.67
1118533453099,-899
1118533453099,-165.67


所要结果也没相加
11902110884708,-33
11902110884708,-34

sunzhiguolu

@elu_ligao
大神厉害, 学习了.