Mario,
Are the characters seperated by spaces? length() only work to check the total number of characters
including spaces in a string. You can use either trim() or strip() to remove the spaces, depending on that data:
These will return 25 as a length:
length('A B C D E F')
length('ABCDEF ')
.
However, these will return 6 as a length:
length(strip(' ', 'A B C D E F'))
length(trim('ABCDEF '))
Assuming you've created a condition with type "advanced", paste one of the following in your "Advanced Condition" box:
Using TRIM:
=length(trim(@(1,1,30))) <= 20OR using STRIP:
=length(strip(' ', @(1,1,30))) <= 20