I have two input files28a39a289906c01159f999a68996091a tom@dong.com274d1d2c7e931fb55ac0c91dd41f2be7 go@far.com44d25d3b1b70b240d5058f1be1cef576 person@domain.com2227a768f6d253b7bf81bb4ecb15b52d person@gmail.comand28a39a289906c01159f999a68996091a274d1d2c7e931fb55ac0c91dd41f2be744d25d3b1b70b240d5058f1be1cef5762227a768f6d253b7bf81bb4ecb15b52di'm trying to exclude all the rows in file 1 where file2 and file1 have a matching column 1.md5 suppression.What i could find was awk 'NR==FNR{a[$1]=$0;next}{print a[$2]}' $1 $2which i know is pretty close just not sure what i did before to do what i want to do now.
Sorting columns from two files with awk
text processing;awk
If order doesn't matter (i.e. just exclude all emails with an md5 in the exclude file) and you're not wedded to awk, use join:join -v 1 -j 1 <(sort emails) <(sort excludes)-v 1 tells it to print lines in the first file (emails) that don't have a corresponding line in the second file (excludes).-j 1  tells it to only look at the first column of each.  If you want to use awk, I believe this should work:awk 'NF==1{exclude[$1]++} NF==2&&!exclude[$1]' excludes emailsOr if the two files correspond line-by-line and you only want to exclude, e.g. line 2 if both have the same hash on that particular line, use this:awk 'NF==1{hash[FNR]=$1} NF==2&&hash[FNR]!=$1' excludes emails