Lower() converts all the characters in the input string to lower case.
Syntax:
Lower(text)
Return data type: string
Arguments
Argument
Description
text
The string to evaluate.
Example: Chart expression
Example
Result
Lower( 'abcD' )
Returns abcd
Example - Lower fundamentals
Overview
Open the Data load editor and add the load script below to a new tab.
The load script contains:
A dataset which is loaded into a data table called Example.
One field in the data table called InputText.
Load script
Example:
Load * inline [
InputText
rHode iSland
washingTon d.C.
new york
];
Results
Load the data and open a sheet. Create a new table and add this field as a dimension:
InputText
Create the following calculated dimension:
=Lower(InputText) to convert all characters in the InputText field to lowercase.
Results table
InputText
Lower(InputText)
new york
new york
rHode iSland
rhode island
washingTon d.C.
washington d.c.
The output of the Lower function converts all values to lowercase.
The following code shows how to use the function in a load script.
Load
String,
Lower(String)
Inline
[String
rHode iSland
washingTon d.C.
new york];
Results table
String
Lower(String)
rHode iSland
rhode island
washingTon d.C.
washington d.c.
new york
new york
Example - Lower scenario
Overview
A dataset of customer data contains email addresses with mixed-case characters for the domain. The company wants to standardize these addresses to use all lowercase.
Open the Data load editor and add the load script below to a new tab.
The load script contains:
A dataset which is loaded into a data table called Example.
The following fields in the data table:
CustomerID
EmailAddress
Inquiry
Load script
Example:
Load * inline [
CustomerID, EmailAddress, Inquiry
1001,john.doe@Gmail.com, Inquiry about product return
1002,mary.jane@yahoo.com, Inquiry about order status
1003,a.smith@GMAIL.COM, Inquiry about shipping details
1004,lisa.black@outlook.com, General product inquiry
1005,james.wong@Yahoo.COM, Question about pricing
];
Results
Load the data and open a sheet. Create a new table and add these fields as dimensions:
CustomerID
EmailAddress
Create the following calculated dimension:
=Lower(EmailAddress) to separate the domain part of the email as a new column and convert the characters to lowercase.
Results table
CustomerID
EmailAddress
Lower(EmailAddress)
1001
john.doe@Gmail.com
john.doe@gmail.com
1002
MARY.JANE@YAHOO.COM
mary.jane@yahoo.com
1003
a.smith@GMAIL.COM
a.smith@gmail.com
1004
lisa.black@Outlook.Com
lisa.black@outlook.com
1005
james.wong@Yahoo.COM
james.won@yahoo.com
The output of the Lower function returns all email addresses in lowercase.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. The information does not usually directly identify you, but it makes the site work as you expect it to and can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
Privacy & Cookie Notice
Manage Consent Preferences
Strictly Necessary Cookies
Always Active
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
Functional Cookies
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies, then some or all of these services may not function properly. These cookies do not typically store personal information enabling us to identify you, but are based on uniquely identifying your browser and internet device.
Performance Cookies
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site and make it easier to navigate. For example, they help us to know which pages are the most and least popular and see how visitors move around the site. When analyzing this data it is typically done on an aggregated (anonymous) basis.
Advertising Cookies
These cookies may be set through our site by our advertising partners to build a profile of your interests and show you relevant advertisements on other sites. They do not typically store personal information enabling us to identify you, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less relevant advertising.