In this example, we have customers data stored in an Excel sheet. We want to convert CustomerContactName into uppercase. So, we will map the CustomerContactName data field to str data field under the Input node inside the function transformation object.
Right-click on the function transformation object and select Preview Output. You can see that the value inside the data field has been converted into uppercase.
Name
ToUpper
Applicable To (DataType)
String
Purpose
To convert the string into uppercase characters.
Description
Converts a string into uppercase characters.
Return Type
String
Syntax
str [System.String] – string which will be converted.