Filter String Based On a Certain Amount of Characters

[Newest Guy]

Hi,

I have a data item that I am trying to filter to only display data if it is more than 5 characters. Most of the data is 5 numbers, but occasionally it will have more than 5 and also include letters too. Is this possible to filter?

[bus_pass_man]

From what you say, the query item in question would seem to be a text data type as you state that it can have numbers and letters. 

Here's a filter expression which you can use as a guide to what you want to achieve.

char_length({query item} ) > 5



Just as an aside I would recommend you learn a bit about data types as the functions which are relevant to one would not be so for others.

[Newest Guy]

That worked! Thank you!