1

properly join two files based on 2 columns in common:

view story
linux-howto

http://stackoverflow.com – I have two files I'm trying to join/merge based on columns 1 and 2. They look something like this, with "file 1" being much shorter than file 2 and I'd like to find the intersection of these two files: and in case records not matching, last column needs to be updated with different string. example below: File 1: 1047 510 75 Live 1048 510 75 Live 1049 510 75 Live 1627 510 75 Live 1628 510 75 Live 1629 510 75 Live File 2: 1047 510 75 Live 1048 510 75 Live 1049 510 75 Live 107 510 39 Live 108 510 39 Live 109 510 39 Live 117 510 39 Li (HowTos)