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" |
Related Content
-
Format Functions
Format:
Article,
1 min read