Compare columns of different file and paste the contents if matches

Question

Can someone please help me with below. I have two different files and I need to join the files but with some condition.

File1

ABC,10,20,3
GHI,8,6,2

File2

ABC,5000
DEF,6000
GHI,1000

Required output is as below

All columns of file1 + 2nd column of file2 where 1st column of file 1 matches with 1st column of file 2

Output expected

ABC,10,20,3,5000
GHI,8,6,2,1000

What have you tried? since your first column appears to be lexically sorted, it should be trivial using the join command — steeldriver, Commented Oct 19, 2019 at 12:56

Gounou · Accepted Answer · 2019-10-19 16:02:20Z

1

join -t',' -1 1 -2 1 -o 1.1,1.2,1.3,1.4,2.2 <(sort FILE1) <(sort FILE2)

ABC,10,20,3,5000
GHI,8,6,2,1000

answered Oct 19, 2019 at 16:02

Gounou

5493 silver badges5 bronze badges

Or for the lazy ones: join -t',' <(sort FILE1) <(sort FILE2)
– Freddy
Commented Oct 19, 2019 at 17:06

Add a comment |

1 Answer 1