Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

RegEx with extended latin alphabet (ä ö ü è ß) etc

Masond3
8 - Asteroid

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 

FirstNameLastName
MikëLëmpar
DanielleMasoné

 

Current Outcome 

 

FirstNameLastNameFirst Name OutcomeLastName Outcome
MikëLëmparFF
DanielleMasonéTT
FF

 

Expected outcome

 

FirstNameLastNameFirst Name OutcomeLastName Outcome
MikëLëmparTT
DanielleMasonéTT
FF

 

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

2 REPLIES 2
geraldo
13 - Pulsar

@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

 

geraldo_1-1684436781057.png

 

 

binuacs
20 - Arcturus

@Masond3 The below regex checks for all the ASCII characters and Latin letters

binuacs_0-1684447993073.png

 

 

Labels