2

file merge based on common columns

view full story
linux-howto

http://www.unix.com – I have two files 1.txt Code: 34, ABC, 7, 8, 0.9 35, CDE, 6.5, -2, 0.01 2.txt Code: 34, ABC, 9, 6, -1.9 35, CDE, 8.5, -2.3, 5.01 So in both files common columns are 1 and 2 so final o/p should look like Code: 34, ABC, 7, 8, 0.9, 9, 6, -1.9 35, CDE, 6.5, -2, 0.01, 8.5, -2.3, 5.01 I tried using joins , but it's omehow repeating itself. Can anyone suggets better way to do this. (HowTos)