ToProper(String str)

Name	ToProper
Applicable To (DataType)	String
Purpose	To convert the information in the data field to proper case.
Description	Converts the string argument into proper case by capitalizing the first letter of each word.
Return Type	String
Syntax	str [System.String] – string which will be converted.

fxPicture

Example

We have a customers data in which we want to convert the Address information into proper case.

beforeFx

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

dataflow

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

afterFx