I have a list of names and I'm looking to filter the list to return names containing both the last and first names.
Say I'm looking for "Joe Doe"
I have current regex (?:^|\s)Joe|(?:^|\s)Doe
It works, but it returns all rows containing Joe or Doe. I would like it to match names containing only both names, and it could be either "Doe Joe" or "Joe Doe"
source
share