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