Forum Discussion
Filters: Exclude Numbers
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.
My solution filters on whether there are ANY numbers, anywhere in the field. It is not checking whether the field is equal to 0,1,2,3,4,5,6,7,8,9. Rather, it is checking whether those characters are found anywhere in the string.
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
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.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.