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

7 votes133 views1 answer
Ubuntu cmd change user of a file
Shell/Bash
0 vote167 views1 answer
How to open windows terminal from empty folder
Shell/Bash
4 votes122 views3 answers
Ubuntu login as root
Shell/Bash
1 vote131 views1 answer
Powershell connect to serial port
Shell/Bash
4 votes121 views2 answers
Install snap change in progress ubuntu
Shell/Bash
5 votes118 views1 answer
Pip install django-allauth
Shell/Bash
0 vote107 views1 answer
Import csv into mongodb
Shell/Bash
0 vote111 views1 answer
How to set default editor for git bash
Shell/Bash
0 vote111 views1 answer
Linux check speed of file growth
Shell/Bash
0 vote124 views1 answer
"https://restful-booker.herokuapp.com/booking
Shell/Bash