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