- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
The Length of String function (LENGTH_OF_STRING) returns the count of the characters that make up a string including whitespace.
The Length of String function has one required parameter:
Allowed Inputs: field value or text string
Either use the use the Query Builder to choose a field that contains the string or use type a value to enter a text string. While it is technically possible to use a text string with this function it is not recommended.
The output of the Length of String function is positive number that represents the count of the characters in a string. For example LENGTH_OF_STRING(“Test String”) would result in 11. If no value is found then zero is returned.
Most often used in Compare Numbers actions to determine if a string is longer or shorter than a given threshold. To check the length of a description field on an Account record the builder would run LENGTH_OF_STRING(${Account - Description}).