Table of Contents

Proper(text)

Category: Text function


Description

This function converts text to the proper case (or "title case"), i.e. the first letter of each word becomes uppercase, the remaining letters become lowercase.


Arguments

ArgumentTypeDescription
textTextThe text value to convert to proper case.

Return value type: Text


Remarks

This function has no effect on numbers, symbols, or non-printing characters.

Note that words that appear in all uppercase letters retain their case. To convert these strings to proper case, first convert them to lowercase. See examples below.


Examples

proper('hey Jude') //Returns 'Hey Jude'
proper('back to the USSR') //Returns 'Back To The USSR"  (All uppercase words remain uppercase)
proper(lower('UPPER CASE TEXT')) //Returns 'Upper Case Text'  (Convert uppercase words to lowercase first)


See also