Length of String (Expression Function)

Purpose

The Length of String function (LENGTH_OF_STRING) returns the count of the characters that make up a string including whitespace.

Parameters

The Length of String function has one required parameter:

String

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.

Output

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.

Example

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}).

expression function - length of string.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2022