1

awk help: Match data fields from 2 files & output results from both into 1 file

view story
linux-howto

http://www.unix.com – I need to take 2 input files and create 1 output based on matches from each file. I am looking to match field #1 in both files (Userid) and create an output file that will be a combination of fields from both file1 and file2 if there are any differences in the fields 2,3,4,5,or 6. Below is an example of where in file2 the First Name=John, Email=[email protected], and Phone Number=111-222-3333. Since these fields are different than the values in file1 I need the output in file3 based on the example below using awk. Any help would be greatly appreciated. file1: Code: jdoe|Doe|Johnny|11 (HowTos)