Regex Parsing on Names

[sridharthemass]

Hi All,

    Can anyone please suggest on how to flag the below patterns to True from names as per below samples using regex formula tool:

Input              Output

A B C Adam    True

A.B.C Adam    True

A Adam           True

A.B.C.D.E.F Adam    True

Adam-Jones    True

Adam Jones    True

[atcodedog05]

Hi @sridharthemass 

What is the pattern and when will the output be true.

[sridharthemass]

Input              Output

A B C Adam    True

A.B.C Adam    True

A Adam           True

A.B.C.D.E.F Adam    True

Adam-Jones    True

Adam Jones    True

These are the patterns and will be false if any of the above is not true

[danilang]

Hi @sridharthemass 

Name matching is too complex to be solved by a single Regex expression.  No matter how large your sample data set is there will always be exceptions found in real world examples.  You're best best is a 3 pronged approach.

1. Use a join to get all the exact matches.

2. Use fuzzy matching to try and match the remainders. 

3. Flag any remaining items  

Dan

[atcodedog05]

Hi @sridharthemass 

Does it work for you.

Hope this helps : )