Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc
Excerpt

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.

D s
snippetBasic

Column reference example:

D code

derive type:single 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:

D code

derive type:single value:PROPER('Hello, world')

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

D s
snippetSyntax

D code

derive type:single value:PROPER(column_string)

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

D s lang 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.

D s
snippetusage

Required?Data TypeExample Value
YesString literal or column referencemyColumn

D s
snippetExamples

Example - uppercase, lowercase, propercase functions

Include Page
EXAMPLE - Case Functions
EXAMPLE - Case Functions

D s also
labelstring