In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors