0
capitalize
To capitalize the first letter of each word
This function converts the first character of each word in a text into a capital letter. This can be handy to correct entered data that should always begin with a capital letter, for example, the first and last name of a person.
In Trigger after update, you could add the function to automatically correct the entered data.
Syntax
capitalize(string)
Return
string
Examples
capitalize('Last name')Result: Chamani (with the field Last name = chamani)
capitalize("Sam chamani")Result: Sam Chamani
'Last name' := capitalize('Last name')Result: Dacosta (with the field Last name = dacosta) for example added in the Trigger after update in the field settings of the text field Last name.
See also
lower, which returns a string in lower case.
upper, which returns a string in the upper case.
Reply
Content aside
Related Articles