UNIX and Linux Forums - Search Results

Showing results 1 to 2 of 2 Search took 0.01 seconds. Search: Posts Made By: suneet17

Forum: Shell Programming and Scripting 03-21-2013

Shell Scripting Vlookup

4,056

Posted By

with join join -1 3 -2 2 -o "1.1 1.2 2.2 2.3"...

with join
join -1 3 -2 2 -o "1.1 1.2 2.2 2.3" file1 file2

Sorry, this only looks at the 3rd field in file1 and the 2nd field in file2. Not what the OP wanted.

Forum: Shell Programming and Scripting 03-21-2013

Shell Scripting Vlookup

4,056

Posted By

awk 'NR==FNR{a[$1$3]=$0;next}{print a[$1$2],$3;}'...

awk 'NR==FNR{a[$1$3]=$0;next}{print a[$1$2],$3;}' file1 file2

Guru.

Showing results 1 to 2 of 2