- 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 - lowercase [2016/09/14 18:19] |
expression function - lowercase [2016/09/14 18:19] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Lowercase (Expression Function) ====== | ||
| + | |||
| + | ===== Purpose ===== | ||
| + | The **Lowercase** function (LOWERCASE) changes the case of a text value to all lower-case. | ||
| + | |||
| + | {{::lowercase_initial.png?direct&600|}} | ||
| + | ===== Parameters ===== | ||
| + | The **Lowercase** function has one required parameter: | ||
| + | |||
| + | ==== Value ==== | ||
| + | |||
| + | 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 **Lowercase** function is a string with all the values converted to lowercase. For example LOWERCASE("The Quick Brown Fox") would result in "the quick brown fox". | ||
| + | |||
| + | ===== Example ===== | ||
| + | |||
| + | The output of the **Lowercase** function is commonly used to take user input and make sure it is more uniform by making sure all the characters are in the same case. For example LOWERCASE("Y") and LOWERCASE("y") both result in "y". | ||
