Proper (String str)

Name	Proper
Applicable To (DataType)	String
Purpose	To capitalize the first letter of each word in a string.
Description	Capitalizes the first letter of each word and returns the resulting string.
Return Type	String
Syntax	str [System.String] – string to convert

Properties

Example

We have a customers' dataset in which we want to convert the ContactTitle field into proper case.

1-output

We will map the ContactTitle data field to the str under the Input node inside the function transformation object.

dataflow

You can see that the data inside the ContactTitle data field has been converted to proper case.

2-output