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
Hi @sridharthemass
What is the pattern and when will the output be true.
These are the patterns and will be false if any of the above is not true
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
Does it work for you.
Hope this helps : )
