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.






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.

Last updated