ToLower(String str) – String

Name ToLower
Applicable To (DataType) String
Purpose To convert the string argument into lowercase characters.
Description Converts the string argument into lowercase characters.
Return Type String
Syntax str [System.String] – string which will be converted.

properties

Example

In this example, we have a customer’s data in which we want to convert the CustomerID information into lower case. Map the CustomerID to the str data field under the Input node inside the function transformation object.

dataflow

Right-click on the header of function transformation object and select Preview Output. You can see that all the CustomerIDs have been converted into lower case.

output