Function: Len
Description
Returns the length of a string as a number.
Syntax
Len(string)
Arguments
string can be a constant, a character field, a memo field,an expression that results in a string or a function that returns a string.
Return value
This function returns a number representing the length of string.
Note: If string is a memo field, the return value accounts for a Carriage Return and Line Feed character at the end of each line, except for the last line. For example, a 5 line memo field with a template width of 20 will return a length of 108 (5 lines * 20 characters to account for the data in the field, plus 4 lines * 2 characters to account for the Carriage Return and Line Feed characters that Monarch Classic adds to all but the last line).
Calculated field example
If the City field contained the value Pittsfield or Chelmsford, the following calculated field expression would return 10: Len(City)
Note: Len(City) returns the actual length of the City field, not the length of the data in the field. If the field contains trailing spaces, use the RTrim function inside the Len function to first remove the trailing spaces, e.g.: Len(RTrim(City)).
Filter/Find example
Records with a blank Job_title field can be selected or found using the expression: Len(Job_title)=0 or len(RTrim(Job_title))=0
© 2024 Altair Engineering Inc. All Rights Reserved.