PROPER Function

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.

Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation