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.
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.
