EXAMPLE - Case Functions

Source:

In the following example, you can see a number of input values in the leftmost column. The output columns are blank.

inputuppercaselowercasepropercase
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:

inputuppercaselowercasepropercase
AbCdEfGh IjKlMnOABCDEFGH IJKLMNOabcdefgh ijklmnoAbcdefgh 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.