Proper (String str) – String

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

Example

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

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

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