Category: Text function

This function returns the number of characters (length) in the text value.

This function can be used to determine if there are unexpected non-printing characters in a text string.

Return value type: Number

The number of characters returned includes unseen, non-printing characters (space, line feed, tab, etc.)

text is implicitly converted to text values if required

len('Telecommunications') = 18
len('Computer sciences') = 17  //Includes the space
len(' Genetics ') = 10  //Includes leading and trailing spaces
len('Psychology' & char(9)) = 11  //char(9) = tab, included in the length
len(1000000) = 7  //Implicit conversion of a numeric value to text
len('') = 0  //An empty string has a length of 0
len([MyClass]) = 12  //Using a field name; [MyClass] = 'Astrophysics'

• IfEmpty(value, new_value)
• IsEmpty(value)