- 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 - propercase [2016/09/14 18:19] |
expression function - propercase [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Propercase (Expression Function) ====== | ||
+ | ===== Purpose ===== | ||
+ | The **Propercase** function (PROPERCASE) Capilalizes the first letter of each word in the value provided and converts all other characters to lower case. | ||
+ | |||
+ | {{::propercase_initial.png?direct&600|}} | ||
+ | ===== Parameters ===== | ||
+ | The **Propercase** 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 **Propercase** function is a string with the first letter of each word capitalized and converts all other characters to lower case. For example PROPERCASE("Platform as a SERVICE") would result in "Platform As A Service". | ||
+ | |||
+ | ===== Example ===== | ||
+ | |||
+ | The output of the **Propercase** function is commonly used to try and clean up user provided values. For example if a value for a "First Name" [[Field|field]] is entered as "bob" on a [[Record|record]] in the Contact [[Table|table]] then the **Propercase** function could be used to clean it up by doing PROPERCASE(${Contact - First Name}) to get the result "Bob". |