Numbers in a string format

[BarleyCorn]

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! 

[BenMoss · Accepted solution]

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 · Accepted solution]

Thanks Ben,

Worked a treat!