LEN( )
Counts the number of characters in a string.
Syntax
LEN(source)
Argument
source
The string expression to evaluate.
Returns
The number of characters in the specified string.
Example
The following example returns the length of each value in the ProductCode field:
LEN([ProductCode])
The following example uses LEN( ) in conjunction with the RIGHT( ) and FIND( ) functions to display the characters that appear after the hyphen in a product code. RIGHT( ) extracts a substring of a specified length, starting from the last character. In this example, the length of the entire string returned by LEN( ) minus the length up to the hyphen is the number of characters to display:
RIGHT([ProductCode], LEN([ProductCode]) - FIND("-" , [ProductCode]))
If the product code is ModelA-Ford, the expression returns Ford.

Additional Links:

Copyright Actuate Corporation 2012