Case Function
Description:
Apply a specified case to some text.
Returns:
Text
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Text | The text. |
2 | Text | The case. |
Examples:
When using functions inside a field, remember the field brackets:
{Case(BuyerName, "upper")}
Note you can also achieve this using the format keyword in a field:
{BuyerName Format Upper}
Expression | Result |
|---|---|
Case( "111 ninth avenue,new york,usa", "upper" ) | "111 NINTH AVENUE,NEW YORK,USA" |
Case( "111a ninth avenue,new york,USA", "lower" ) | "111a ninth avenue, new york,usa" |
Related Content
-
Format Functions
Format:
Article,
1 min read