Filter column based on length of cells

Question

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 Answer

Hi @Tmanuela,

try this:

Length([columnname]) <= 50

hope this helps,

Greg

Emil_Kos · Accepted Answer

Hi @Tmanuela,

Please find a solution attached.

CarlDi · Accepted Answer

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