Alpha Numeric Filter

[Viswadeep]

Hi 

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]

Hi @Viswadeep,

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.

Source: https://help.alteryx.com/11.0/Reference/Functions.htm (section Operators)

Thanks,

Paul Noirel

Sr Customer Support Engineer

[MarqueeCrew · Accepted solution]

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

Cheers,
Mark

[Viswadeep]

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