awk read one delimited file, search another delimited file

Shell Programming and Scripting
1

Hello folks, I have another doozy. I have two files. The first file has four fields in it. These four fields map to different locations in my second file. What I want to do is read the master file (file 2 - 23 fields) and compare each line against each record in file 1. If I get a match in all four fields, I want to toss that record out.

File1:
Group|Cur_ID|Cur_Name|Hostname
  1     8        9     13 (where they map in file2)  

File2:
Group|OldID|Old_Name|Old_Sess|Old_Sess_Date|Old_Type|Old_UID|Cur_ID|Cur_Name|Cur_Sess|Cur_Sess_Date|Cur_Type|Hostname|Acct|MRR|ASR|BE|CD|Cur_UID|Fld20|Fld21|Fld22|Fld23

I gave a sample of what the headers would basically be for all the fields, but the idea is the same as i'm more concerned with matching fields up as the values change for each record.

2

What file you want to eliminate the records from? file1 or file2?

3

I want to eliminate records from file 2. File one has the matching field criteria that I want to find in file 2 (master file) and reject.

4 
awk '
  FNR==NR {f1[$1,$2,$3,$4];next}
  !(($1 SUBSEP $8 SUBSEP $9 SUBSEP $13) in f1)
' file1 file2
5

Thank you so much for your help. I had to modify it a little, but it worked. Here is the updated code that worked:

awk -F\| '
  FNR==NR {f1[$1,$2,$3,$4];next}
  !(($1 SUBSEP $8 SUBSEP $9 SUBSEP $13) in f1)
' file1 file2 >> new_outfile