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
Solved! Go to Solution.
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
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