Differences

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

Link to this comparison view

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"​.
expression function - propercase.txt ยท Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024