LOWER Function
All alphabetical characters in the input value are converted to lowercase in the output value.
Input can be a column reference or a string literal.
Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.
Basic Usage
Column reference example:
lower(MyName)
Output: Returns the string value from the MyName column in lowercase.
String literal example:
lower('Hello, World')
Output: The string hello, world is returned.
Syntax and Arguments
lower(column_string)
Argument | Required? | Data Type | Description |
|---|---|---|---|
column_string | Y | string | Name of the column or string literal to be applied to the function |
For more information on syntax standards, see Language Documentation Syntax Notes.
column_string
Name of the column or string constant to be converted.
Missing string or column values generate missing string results.
String constants must be quoted (
'Hello, World').Multiple columns and wildcards are not supported.
Usage Notes:
Required? | Data Type | Example Value |
|---|---|---|
Yes | String literal or column reference | myColumn |
Examples
Astuce
For additional examples, see Common Tasks.
Example - uppercase, lowercase, propercase functions
This example demonstrates functions that can be used to change the case of String values.
Functions:
Item | Description |
|---|---|
UPPER Function | All alphabetical characters in the input value are converted to uppercase in the output value. |
LOWER Function | All alphabetical characters in the input value are converted to lowercase in the output value. |
PROPER Function | Converts an input string to propercase. Input can be a column reference or a string literal. |
Source:
In the following example, you can see a number of input values in the leftmost column. The output columns are blank.
input | uppercase | lowercase | propercase |
|---|---|---|---|
AbCdEfGh IjKlMnO | |||
go West, young man! | |||
Oh, *(*$%(&! That HURT! | |||
A11 w0rk and n0 0play makes Jack a dull boy. |
Transformation:
To generate uppercase, lowercase, and propercase values in the output columns, use the following transforms:
Transformation Name | |
|---|---|
Parameter: Columns | uppercase |
Parameter: Formula | UPPER(input) |
Transformation Name | |
|---|---|
Parameter: Columns | lowercase |
Parameter: Formula | LOWER(input) |
Transformation Name | |
|---|---|
Parameter: Columns | propercase |
Parameter: Formula | PROPER(input) |
Results:
input | uppercase | lowercase | propercase |
|---|---|---|---|
AbCdEfGh IjKlMnO | ABCDEFGH IJKLMNO | abcdefgh ijklmno | Abcdefgh Ijklmno |
go West, young man! | GO WEST, YOUNG MAN! | go west, young man! | Go West, Young Man! |
Oh, *(*$%(&! That HURT! | OH, *(*$%(&! THAT HURT! | oh, *(*$%(&! that hurt! | Oh, *(*$%(&! That Hurt! |
A11 w0rk and n0 0play makes Jack a dull boy. | A11 W0RK AND N0 0PLAY MAKES JACK A DULL BOY. | a11 w0rk and n0 0play makes jack a dull boy. | A11 W0rk And N0 0play Makes Jack A Dull Boy. |