I have a little problem with filtering my Grid and I hope that you can help me.
I am currently in the process of developing a grid in which I list all my projects with the associated data.
In the first column I list the project number in the form of strings. Usually all project numbers have a length of 9 characters. Due to certain circumstances, I also have entries of projects in my database where the project number is shorter than 9. (but I urgently need this data for another use case)
In the grid that I am developing here, I only want to list projects with a project number length of 9 characters. Is there any filter option where I can specify how long a cell's value must be for it to be displayed?
If a value has less than 9 characters, the entire row should be hidden. It is important to note: the rows cannot be edited and are only listed using a READ function.
In the picture (attachment) you can see an example. In this case, the first two rows should be filtered and hidden.
Thanks in advance