Bash vlookup function

# Example usage:
awk 'FNR==NR{a[$1]=$2; next}; {if($9 in a) {print $0, "\t"a[$9];} else {print $0, "\tNA"}}' input_file_1 input_file_2
# This command does a VLOOKUP-type operation between two files using
#	awk. With the numbers above, column 1 from input_file_1 is used 
#	an a key in an array with column 2 of input_file_1 as the match for 
#	the key. Column 9 of input_file_2 is then compared to the keys from
#	input_file_1 and any matches return the associated match from 
#	input_file_1 (here, column 2).

Source: unix.stackexchange.com

Similar codes

17 votes165 views2 answers
Linux while loop
Shell/Bash
15 votes153 views2 answers
Show env in bash
Shell/Bash
102 votes166 views6 answers
How to undo a commit
Shell/Bash
0 vote115 views1 answer
Hide ssd icon in ubuntu
Shell/Bash
0 vote158 views2 answers
Powershell get ip address
Shell/Bash
0 vote149 views1 answer
Copy a file from home directory to other directory in linux
Shell/Bash
0 vote148 views1 answer
-v /var/run/docker.sock jenkins/jenkins
Shell/Bash
-2 votes147 views2 answers
Symfony install website skeleton
Shell/Bash
12 votes152 views6 answers
Ubuntu start mongodb
Shell/Bash
0 vote152 views1 answer
Weka explorer for ubuntu
Shell/Bash