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

2 votes330 views2 answers
Phpunit run single test
Shell/Bash
0 vote357 views1 answer
Decompress bz2
Shell/Bash
41 votes394 views6 answers
Ssh into docker container
Shell/Bash
0 vote374 views1 answer
Conda create tensorflow-gpu environment
Shell/Bash
0 vote371 views1 answer
Compile protobufs to c code
Shell/Bash
0 vote380 views1 answer
Git fatal pack has bad object at offset
Shell/Bash
0 vote361 views1 answer
Second monitor after update went black
Shell/Bash
0 vote437 views1 answer
Select loop bash
Shell/Bash
1 vote356 views1 answer
How to find address git is pushed
Shell/Bash
0 vote348 views1 answer
Strg s crashed vim
Shell/Bash