Hi I’m trying to match two difference sources of names is a search that displays multiple names. How can I match the two names if they are slightly different.
Such as a search in the software for Doe, John. The search results maybe either be with an initial or with the spouse as part of the name. Doe, John A. or Doe, John and Doe, Jane. There may also be multiple people with different initial and the same first and last name.
What should I do to tackle this problem multiple IFs each with a different Is Match?
I want to match the two strings and then from there use the index of the search results table to click the name of the person.