Forum Discussion
Solved
Filters: Exclude Numbers
Hello Is it possible to exclude numbers or only contain letters in a filter. Regards Heinrich
Hi Heinrich so, either take my first solution, there are 10 possible numbers that any number can start with and in advanced filtering say starts with instead of equals or contains.
Or create a Calculated Column
VizFilter =
if(left(Table[YourColumn], 1)
in {"1","2","3","4", "5", "6", "7", "8", "9", "0"}, 1, 0)
Use it as a filter.
Thank you kpost
It was my error. I wanted to filter out every name that starts with a number
Do you have such a solution
Regards
Heinrich
olgad nailed it.
If the filter condition is that you want to exclude names that start with a number, rather than names that contain a number then use:
if(left(Table[YourColumn], 1)
in {"1","2","3","4", "5", "6", "7", "8", "9", "0"}, 1, 0)
rather than CONTAINSSTRING.
then use that as a filter on the visual and do a 'basic' filter on fields where it equals zero.