ToLower(String str)

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