The LOWER function converts text values to lowercase.
The LOWER function converts text values to lowercase.
LOWER(Text [, Locale])
Argument | Data type | Description |
Text (required) | Text | The text to make lowercase. |
Locale | Keyword | The locale to use. Only has an effect with certain languages. The available locales are based on ISO 639 and ISO 3166 codes. |
The LOWER function returns a text value.
LOWER(Customer comments)
The Locale argument accepts ISO language codes that correspond to the locales available in Java 8. You can use either:
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.
In Polaris, you cannot use the Locale argument with the LOWER function.
In the Classic Engine, you can use the Locale argument.
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 LOWER to make the product categories lowercase, 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 |
Lowercase 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 |
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 that uses the LOWER function to make them lowercase.
Accented character | Cyrillic | Greek | Chinese | Japanese | Korean | |
Uppercase character | Å | Ж | Ψ | 中 | あ | ㅏ |
Lowercase character
| å | ж | ψ | 中 | あ | ㅏ |
The LOWER 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.
If you use the LOWER function with a text string that contains an uppercase I and use the tr_tr code for the Locale argument, the result contains a lowercase i without a dot, ı.
LOWER("I", tr)
The result of this formula is ı.
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.