I am querying one file with the other file and have them as following:
File1:
Angela S Darvill| text text text text
Helen Stanley| text text text text
Carol Haigh S|text text text text .....
File2:
Carol Haigh
Helen Stanley
Angela Darvill
This command:
awk 'NR==FNR{_[$1];next} ($1 in _)' File2.txt File1.txt
returns lines that overlap, BUT doesn’t have a strict match. Having a strict match, only Helen Stanley should have been returned.
How do you restrict awk on a strict overlap?
>Solution :
With your shown samples please try following. You were on right track, you need to do 2 things, 1st: take whole line as an index in array _ while reading file2.txt and set field seapeator to | before awk starts reading file1
awk 'NR==FNR{_[$0];next} ($1 in _)' File2.txt FS="|" File1.txt