topic Alpha Numeric Filter in Alteryx Designer Desktop Discussions

Alpha Numeric Filter

Viswadeep — Thu, 24 May 2018 04:49:01 GMT

I need to filter an alpha numberic word eg: I5.5 or Q45.3 or I765.3 or Q78.99

How will i filter all these in a single go

Thank you

PaulN — Thu, 01 Feb 2018 14:39:53 GMT

If you want to filter on exact value, you could use a Filter tool with a formula like the following:

[valueToCheck] IN ("I5.5","Q45.3","I765.3","Q78.99")

Where [valueToCheck] is the name of the field you would like to filter on.

Thanks,

Paul Noirel

Sr Customer Support Engineer

MarqueeCrew — Thu, 01 Feb 2018 14:43:23 GMT

Regex_match([field],"\u\d+\.\d+") should work for you.

Cheers,
Mark

Viswadeep — Fri, 02 Feb 2018 04:48:33 GMT

Thanks mark,

It worked, i need to add on a few things

Data like the below

"-SBI35.2/HLQ34.0" "-SBI35.4/HLQ34.1"

I am able to build on from your expression and able to filter out the below data using 'Regex_match([F1],"-?\u+\d+\.\d+")'

"-SQI70.1"

So how do I add on that "/" to filter that out in the same expression

Thank you