The transformation language includes a group of functions to eliminate data errors. You can complete the following tasks with data cleansing functions:
Test input values.
Convert the datatype of an input value.
Trim string values.
Replace characters in a string.
Encode strings.
Match patterns in regular expressions.
The transformation language includes the following data cleansing functions: