I have two tables with different numbers of columns and rows. I want to find rows using a common column (column B is in common). Here is an example. Could you please help?
file1.txt
A B C D
a b c d
i ii iii iV
* ** # ##
file2.txt
E B
f ff
h b
g gg
k ii
output:
A B C D E
a b c d h
i ii iii iV k
I know how to merge two tables to print alternative lines in a new file, but I want to merge every two lines from file1.txt with one line from file2.txt. As an example:
file1.txt is
A a aa
B b bb
C c cc
D d dd
and file2.txt is
E e ee
F f ff
I want to have
A a aa
B b bb
E e ee
C c cc
D d dd
F f ff
I have two text tables as below:
file1.txt
1 A a
2 B b
3 C c
4 D d
file2.txt
A x i
C z iii
D w iiii
B y ii
I want to have
final.txt
1 A a x i
2 B b y ii
3 C c z iii
4 D d w iiii