RegEx Match for wild characters

Hello folks,

I have been trying some solutions from the community to find/identify the wild characters like:

IF STRCSPN([customer_name],"#,'@^.&ouml;&#940;&acirc;&euro;&Atilde;&Yuml;") < LENGTH(Trim([customer_name])) THEN
	1
ELSE
	0
ENDIF

or with this

IF (REGEX_Match([customer_name], "[[:alpha:]]+") AND
REGEX_Match([customer_name], "\d+")) THEN 1 ELSE 0 ENDIF

but none of these would return me a desired result for the example below:

cust_nbr          cust_name                RegEx_Match

9999999	          &aelig;&tilde;&yen;&ccedil;&sect;&lsaquo;&egrave;&circ;&ordf;&ccedil;&copy;&ordm;&egrave;&acute;&iexcl;&auml;&raquo;&frac12;&aelig;      True
3333333	          &ccedil;&frac34;&#381;&aring;&iquest;&cedil;&eacute;&pound;&Yuml;&aring;&ldquo;&uml;&iuml;&frac14;&circ;&aring;&sup1;&iquest;&aring;&middot;&#382;    True
2222222	          &aring;&yacute;&copy;&aelig;&Yacute;&yen;&eacute;&iexcl;&para;&aring;&middot;&sect;             True
111111            Andesdd123               False

So, is there some RegEx formula that will return me this?

Thank you in advance.

Regex

Tips and Tricks

Accepted answers

atcodedog05

Hi @cito

Here is my take on it.

Workflow:

Hope this helps : )

special char.yxmd

All comments

Maskell_Rascal

Hi @cito

Try this:

!IsEmpty(REGEX_Replace([cust_name], '[A-Za-z0-9]', ''))

My field RegEx_Match is a boolean, so I don't need an IF statement, but you could put this into an IF statement if needed.

Workflow attached.

Cheers!

Phil

RegExMatch for wild characters.yxmd

cito

@Maskell_Rascal is does not work in my flow.

Attached is my flow and as you can see it returns me all TRUE. Am I doing something wrong?

RegEx_Cust_Name.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703