Help searching with multiple words
Posted: Tue Jul 22, 2014 2:36 pm
Hi,
I have a text file with that contains names and addresses. I am trying to search for a list of about 20 names to remove them from the file. It appears the space in between the first and last name is my issue. My question is how can I search for several names and get hits for just those names?? Below is an example, and thank you in advance for your help.
Test file is formatted like this:
MIKE SMITH 1111 WASHINGTON AVE. OAKLAND CA 90210
JIM JONES 2222 WASHINGTON AVE. OAKLAND CA 90210
JOHN HANCOCK 1234 WASHINGTON AVE. OAKLAND CA 90210
I tried searching under the "Regular Expressions" tab using MIKE SMITH|JIM JONES|JOHN HANCOCK| but this found everyone with the first name of MIKE instead of just MIKE SMITH. How can I search the file for just MIKE SMITH?
Thank you...
I have a text file with that contains names and addresses. I am trying to search for a list of about 20 names to remove them from the file. It appears the space in between the first and last name is my issue. My question is how can I search for several names and get hits for just those names?? Below is an example, and thank you in advance for your help.
Test file is formatted like this:
MIKE SMITH 1111 WASHINGTON AVE. OAKLAND CA 90210
JIM JONES 2222 WASHINGTON AVE. OAKLAND CA 90210
JOHN HANCOCK 1234 WASHINGTON AVE. OAKLAND CA 90210
I tried searching under the "Regular Expressions" tab using MIKE SMITH|JIM JONES|JOHN HANCOCK| but this found everyone with the first name of MIKE instead of just MIKE SMITH. How can I search the file for just MIKE SMITH?
Thank you...