Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Numbers in a string format

BarleyCorn
8 - Asteroid

Hello Alteryx Community!

 

I have a large column of string data that has randomly occurring numbers (for example 88.214.193.98) - column is defined as a string in the select tool.

 

I want to filter (or regex) out all the numbers and just have a true string column, see attached excel - the "domain_name" column.

 

Thanks! 

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

You can use the regex_match() function within the filter tool to filter out values based on a pattern.

 

What this pattern is should be defined by yourself, but something like the below will filter to create two streams, one which has characters in and another which has only numeric type domains in.

 

.[[:alpha:]].+

See attached example.

 

Ben

BarleyCorn
8 - Asteroid

Thanks Ben,

 

Worked a treat!

Labels