- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
expression function - length of string [2016/09/14 18:19] |
expression function - length of string [2016/09/14 18: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}). |