Propercase (Expression Function)

The Propercase function (PROPERCASE) Capilalizes the first letter of each word in the value provided and converts all other characters to lower case.

The Propercase function has one required parameter:

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.

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”.

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”.