Filter column based on length of cells

[Tmanuela]

Hello Community,

I try to find a solution to validate the length of a column by allowing maximum 50 characters in a cell, those which not met criteria would be excluded in the False Anchor (perhaps using filter formula?) 

I am pretty new here and did not find yet a formula to count characters within a cell.. 

Thank you!

[Greg_Murray · Accepted solution]

Hi @Tmanuela,

try this:

Length([columnname]) <= 50

hope this helps,

Greg

[Emil_Kos · Accepted solution]

Hi @Tmanuela,

Please find a solution attached. 

[CarlDi · Accepted solution]

hi @Tmanuela try using the "length" expression in the formula tool. this gives you the amount of characters in a particular field. then use the filter to exclude anything over 50 in the "length" field

[Tmanuela]

Hi @Greg_Muray , 

Thank you very much, was that simple!

Manuela

[Tmanuela]

Thank you very much, @Emil_Kos. This was really helpful. 

However, don't know why @ mention is not working though..

Manuela

[Emil_Kos]

Hi @Tmanuela,

Thank you for marking my post as a solution.

Good luck analyzing!