Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

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:

Output: Returns the string values in the MyName column value written in Proper Case. 

String literal example:

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

Syntax


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.


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.

 

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 11 rates

This page has no comments.