EXAMPLE - Case Functions

Contents:

Expand all Collapse all

Scheduled Maintenance: docs.trifacta.com will be offline for maintenance at 3:00pm UTC on Tuesday March 28 for about 15 minutes.

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.