RegEx Match for wild characters

[cito]

Hello folks,

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

IF STRCSPN([customer_name],"#,'@^.öάâ€ÃŸ") < 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	          æ˜¥ç§‹èˆªç©ºè´¡ä»½æ      True
3333333	          美忸食哨（广州    True
2222222	          åý©æݥ顶巧             True
111111            Andesdd123               False

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

Thank you in advance.

[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

[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?

[atcodedog05 · Accepted solution]

Hi @cito 

Here is my take on it.

Workflow:

Hope this helps : )

[cito]

@atcodedog05 - Yeap, works great man. Thanks a lot!

[atcodedog05]

Happy to help : ) @cito 

Cheers and have a nice day!