ToProper(String str) – String

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