Numbers in a string format

Question

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!

ComscoreTestDataV1.xlsx

BenMoss · Accepted Answer

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 Answer

Thanks Ben,

Worked a treat!