I have a Name Column in my Excel (and DataTable) which should go through Is Mach Activity to assess if the Name contains “pte”, “ltd” or any other sign of non-individual. (Almost over 99% lines in the Name Column do not contain these.)
Whatever a value go through Is Mach Activity, however, Is Mach Activity always returns true regardless of actual presence of strings such as “pte”, “ltd” or whatsoever = 100% true currently, whereas it is supposed to be 99% false.
I am using RegEx Builder to generate Regular Expression. If using String.Contains(“pte”) Or String.Contains(“ltd”)… it gives correct boolean false. There should be something wrong with how to generate Regular Expression, I suppose?
Kindly help me figure out what’s up with my Regular Expression. Thank you in advance.