We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Filter out rows that contain numbers

Carlyn
8 - Asteroid
‎08-09-2024 03:43 AM

Hi

Do you know a formula that will let me filter out the rows that contain numbers. I tried to data cleanse, but it is not working.

I also tried to data cleanse and remove the # first and then filter, but not sure of the formula to use to only return the rows without numbers.

Preview file
3 KB
Labels:
Reply
0 Likes
1 REPLY 1
Raj
16 - Nebula
‎08-09-2024 04:04 AM

@Carlyn 
use this 
REGEX_Match([YourFieldName], ".*\d+.*")

mark done if solved.

3295.yxmd
Reply
0 Likes
Live Office Hours
Labels
Top Solution Authors
View All