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

22 votes298 views2 answers
Git remember login
Shell/Bash
0 vote298 views1 answer
Zsh to bash mac
Shell/Bash
0 vote282 views1 answer
System reported a problem ubuntu
Shell/Bash
6 votes281 views5 answers
Laravel npm install
Shell/Bash
1 vote279 views1 answer
Raccourci tor browser sur ubuntu
Shell/Bash
21 votes285 views4 answers
Git push origin master --force
Shell/Bash
17 votes270 views1 answer
Notepad ++ debian
Shell/Bash
0 vote288 views3 answers
Download torrent magnet on linux
Shell/Bash
0 vote257 views1 answer
Microstack.openstack to openstack
Shell/Bash
0 vote276 views1 answer
Hadoop distcp diff snapshot
Shell/Bash