This shows you the differences between two versions of the page.

Link to this comparison view

expression function - length of string [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== 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. ​
 +{{::​length_of_string_initial.png?​direct&​600 |}}
 +===== Parameters =====
 +The **Length of String** function has one required parameter:
 +==== String ====
 +Allowed Inputs: [[Field|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 [[Action Type - Compare Numbers|Compare Numbers]] [[Action|actions]] to determine if a string is longer or shorter than a given threshold. To check the length of a description [[Field|field]] on an Account [[Record|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, 2020