Start Free Trial

Alteryx Designer Desktop Discussions

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

Filter by anything containing a numeric character

jenner85
8 - Asteroid

Hi - 

how would I use the filter tool (or another tool) if I want to filter out any rows that contain anything other than a numeric string? For example in this row I want only to keep the numeric values.

 

thanks!

 

jenner85_0-1682615668223.png

 

2 REPLIES 2
ShankerV
17 - Castor

Hi @jenner85 

 

One way of doing this.

 

 

ShankerV_0-1682615941693.png

 

REGEX_Match([CH ID],"[0-9]+")

 

ShankerV_0-1682615973449.png

 

 

Input was:

ShankerV_1-1682615998765.png

 

Many thanks

Shanker V

binu_acs
21 - Polaris

@jenner85 another approach

binuacs_0-1682616121547.png

 

Labels
Top Solution Authors