Contents:
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 | Edit column with formula |
|---|---|
| Parameter: Columns | uppercase |
| Parameter: Formula | UPPER(input) |
| Transformation Name | Edit column with formula |
|---|---|
| Parameter: Columns | lowercase |
| Parameter: Formula | LOWER(input) |
| Transformation Name | Edit column with formula |
|---|---|
| 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. |
This page has no comments.