Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

This documentation applies to Trifacta Wrangler. Download this free product.
Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.

Converts an input string to propercase. Input can be a column reference or a string literal.Propercase is strict title case. If the first character of any non-breaking segment of letters in the string is an alphabetical character, it is capitalized. Otherwise, the string is unchanged. See the examples below.

Basic Usage

Column reference example:

derive value:PROPER(MyName)

Output: All of the string values in the MyName column value are written to the new column in Proper Case. 

String literal example:

derive value:PROPER('Hello, world')

Output: The string Hello, World is written to the new column.

Syntax

derive value:PROPER(column_string)

ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function

For more information on syntax standards, see Language Documentation Syntax Notes.

column_string

Name of the column or string constant to be converted.

  • Missing string or column values generate missing string results.
  • String constants must be quoted ('Hello, World').
  • Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Examples

Example - uppercase, lowercase, propercase 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.   

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:

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.

 

Your Rating: Results: PatheticBadOKGoodOutstanding! 6 rates

This page has no comments.