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

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.

1 REPLY 1
Raj
16 - Nebula

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

mark done if solved.

Labels
Top Solution Authors