HI All,
I am having a mental block
I have the following formula
if isempty([_CurrentField_]) then 'UT'
elseif REGEX_CountMatches(trim([_CurrentField_]), "[^\x20-\x7eÀÈÌÒÙàèìòùÁÉÍÓÚÝáéíóúýÂÊÎÔÛâêîôûÃÑÕãñõÄËÏÖÜŸäëïöüŸ¡¿çÇŒœßØøÅåÆæÞþÐð\.\,\'\’\–]") = 0 then 'T'
else 'F'
endif
Input
FirstName | LastName |
Mikë | Lëmpar |
Danielle | Masoné |
蔡 | 蔡 |
Current Outcome
FirstName | LastName | First Name Outcome | LastName Outcome |
Mikë | Lëmpar | F | F |
Danielle | Masoné | T | T |
蔡 | 蔡 | F | F |
Expected outcome
FirstName | LastName | First Name Outcome | LastName Outcome |
Mikë | Lëmpar | T | T |
Danielle | Masoné | T | T |
蔡 | 蔡 | F | F |
Which is working great for non English characters i.e. "Japanese, Korean" etc.
However i am wondering how can i extended to include the Latin Unicode range i.e. (ä ö ü è ß)
Looking forward to your help
Regards
Masond3
The formula has to be like this > 0
if isempty([_CurrentField_]) then 'UT'
elseif REGEX_CountMatches(trim([_CurrentField_]), "[^\x20-\x7eÀÈÌÒÙàèìòùÁÉÍÓÚÝáéíóúýÂÊÎÔÛâêîôûÃÑÕãñõÄËÏÖÜŸäëïöüŸ¡¿çÇŒœßØøÅåÆæÞþÐð\.\,\'\’\–]") > 0 then 'T'
else 'F'
endif
these characters are not in your regex pattern