Hi,

I have the following files

1.txt

Code:

a 10
b 11
c 12
d 13
e 14
f 15
g 16
h 17
i 18
j 19
k 20

2.txt

Code:

a 21
b 22
c 23
g 24
h 25
i 26
l 27
m 28
n 29
n 30

3.txt

Code:

a -31
f -35
g -36
h 40
i 42
j 44
k 47
l 48

I am looking for four separate files that has the following content


common_three.txt

Code:

a 10 21 -31
g 16 24 -36
h 17 25 40
i 18 26 42

common_1_and_2.txt

Code:

a 10 21
b 11 22
c 12 23
g 16 24
h 17 25
i 18 26

common_1_and_3.txt

Code:

a 10 -31
f 15 -35
g 16 -36
h 17 40
i 18 42
j 19 44
k 20 47

common_2_and_3.txt

Code:

a 21 -31
g 24 -36
h 25 40
i 26 42
l 27 48

The 1.txt, 2.txt and 3.txt files have more than 1000 records in each of them. I tried using genevenn, but it doesn't give the exact values.

Thanks