CapitalsCase Function

Description:

Capitalise the first letter of each word in a text value.

Note that only the first character in each word may be changed, and none of the other characters.

Returns:

Text

Parameter:

Parameter	Data Type	Description
1	Text	The text.

Examples:

When using functions inside a field, remember the field brackets:

{CapitalsCase(BuyerName)}

Note you can also achieve this using the format keyword in a field:

{BuyerName Format Capitals}

Expression	Result
CapitalsCase( "111 ninth avenue,new york,usa" )	"111 Ninth Avenue,New York,Usa"
CapitalsCase( "111a ninth avenue,new york,USA" )	"111a Ninth Avenue,New York,USA"

This article applies to: