EXAMPLE - Case Functions

Contents:

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.

Transform:

To generate uppercase, lowercase, and propercase values in the output columns, use the following transforms:

set col:uppercase value:UPPER(input)

set col:lowercase value:LOWER(input)

set col:propercase value: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.