| Excerpt |
|---|
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.
Column reference example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:lower(MyName) |
|---|
|
lower(MyName) |
Output: Returns the string value from the MyName column in lowercase.
String literal example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:lower('Hello, World') |
|---|
|
lower('Hello, World') |
Output: The string hello, world is returned.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:lower(column_string) |
|---|
|
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 |
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.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal or column reference | myColumn |
Example - uppercase, lowercase, propercase functions
| Include Page |
|---|
| EXAMPLE - Case Functions |
|---|
| EXAMPLE - Case Functions |
|---|
|
