The UPPER function converts text values to uppercase.
UPPER(Text [, Locale])
|Text (required)||Text||The text to make uppercase.|
The locale to use. Only has an effect with certain languages.
The available locales are based on ISO 639 and ISO 3166 codes.
The UPPER function returns a text value.
Effect of Locale argument
The Locale argument accepts ISO language codes that correspond to the locales available in Java 8. You can use either:
- Two letter ISO 639 language codes such as en, fr, de, or tr.
- Four letter codes made of both ISO 639 language codes and ISO 3166 country codes such as en-us, fr-be, de-at, or tr-tr. However you must replace the hyphen (-) with an underscore (_) in Anaplan, so these become en_us, fr_be, de_at, and tr_tr respectively.
The Locale argument only has an effect on certain languages. For example, Turkish, which is represented by the tr code. In Turkish, there are four versions of the character i. Lowercase and uppercase versions, both with and without a dot.
Related Anaplan functions
General example of UPPER
This example has a Territory list on columns, and two line items on rows. The first line item contains the product categories sold in each region. The second line item contains a formula that uses UPPER to make the product categories uppercase, for use in another system.
|New York||San Francisco||London||York||Tokyo||Osaka|
|Product categories||Accessories, Footwear, Innerwear, Outerwear, Sports Equipment||Accessories, Footwear, Sports equipment,||Accessories, Footwear, Innerwear, Outerwear, Sports Equipment||Outerwear, Sports Equipment||Accessories, Footwear, Innerwear, Outerwear, Sports Equipment||Accessories, Outerwear, Sports Equipment|
Uppercase product categories
|ACCESSORIES, FOOTWEAR, INNERWEAR, OUTERWEAR, SPORTS EQUIPMENT||ACCESSORIES, FOOTWEAR, SPORTS EQUIPMENT,||ACCESSORIES, FOOTWEAR, INNERWEAR, OUTERWEAR, SPORTS EQUIPMENT||OUTERWEAR, SPORTS EQUIPMENT||ACCESSORIES, FOOTWEAR, INNERWEAR, OUTERWEAR, SPORTS EQUIPMENT||ACCESSORIES, OUTERWEAR, SPORTS EQUIPMENT|
Example of UPPER with international characters
In this example, a module contains a list of languages on columns. The are two line items on rows, one that contains international characters, and another one that uses the UPPER function to make them uppercase.
The UPPER function works with most languages without the Locale argument. However, it has no effect on certain languages, such as Chinese, Japanese, or Korean, as these languages do not have uppercase or lowercase characters.
Example of the Locale argument
If you use the UPPER function with a text string that contains a lowercase i and use the tr_tr code for the Locale argument, the result contains an uppercase I with a dot, İ.
The result of this formula is İ.