View Source

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.

Column reference example:

proper(MyName)

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

String literal example:

proper('Hello, world')

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

proper(column_string)

Argument	Required?	Data Type	Description
column_string	Y	string	Name of the column or string literal to be applied to the function

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.

Required?	Data Type	Example Value
Yes	String literal or column reference	`myColumn`

column_string

Example - uppercase, lowercase, propercase functions