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.

Parameters

The Propercase function has one required parameter:

Value

Allowed Inputs: 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 is entered as “bob” on a record in the Contact 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