Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Test condition to find a string contains only numbers and not A-Z or special characters

Naga
8 - Asteroid

Hi Team,

 

I am building a test case for a field, which can hold only numbers and no A-Z char or special characters. If so, then the test case should fail. I tried regex_replace but unable to figure it out.

 

example - 123axy##456 then result should fail

 

Thanks
Naga

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @Naga ,

 

Try this approach. Use regex tool on match.

 

atcodedog05_0-1596898340789.png

 

Hope this solve the requirement.

 

EricMartinson
7 - Meteor

Hi @atcodedog05 ,

 

This solved a similar issue for me. Thank you for posting!

Labels