Filter the Number in the String

[SH_94]

Dear team,

Would like to ask if we can identify the string have the value inside or not as per example below

Example

1. UDKD_DE8

2.DIDI_JEJ

3.DIJ82IDJM

4.83

I would like to ask Alteryx to flag it the non value contain string , in this case, it will flag out the second example -  DIDI_JEJ. May i know how can i do it in Altery? As long as no value found in the string , then it will flag it out or filtering it out.

Thank you.

[IraWatt · Accepted solution]

Hey @SH_94,

If you are wanting to identify text with numbers in you could use Regex. 

REGEX_CountMatches([Example], "\d+")>0

The formula above returns the number of matches made looking for one or more digits (\d+)

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[JosephSerpis]

Hi @SH_94 you can use a regexcountmatch formula to count the amount of digits in your field and then filter out that way.