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.
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.
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.
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 |
Astuce
For additional examples, see Common Tasks.
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. |