LEN
Usage
Use this function to get string length
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER ROW | STRING | .VALUE |
Syntax
1 |
|
Arguments
String
any column field string value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), string constant between quotation marks ("constant"
), System Variables or function-returned string value
Note
This function is mainly used in calculated fields or as argument of conditional expressions
Return Value
Integer
Examples
Example 1
Formula
=LEN("Welcome to eLegere")
Description
Return the length of the string Welcome to eLegere
Result
18
Example 2
Formula
=LEN(#StorageExample.Column.VALUE)
Description
Return the length of the field Column of Storage StorageExample
Result
Integer