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
– steeldriver, Commented Oct 19, 2019 at 12:56

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

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

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

1 Answer 1