Page tree

NOTE:  Trifacta Wrangler is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

   

This example demonstrates functions that can be used to change the case of String values.

Functions:

ItemDescription
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.

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.

See Also for EXAMPLE - Case Functions:

This page has no comments.