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.
Solved! Go to Solution.
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
@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 - Yeap, works great man. Thanks a lot!
Happy to help : ) @cito
Cheers and have a nice day!