Use the String parameters window to customize how the Clean Data transformer performs the find and replace tasks. You can specify string settings and an escape character.
All of the following steps are optional.
To customize Clean Data transformer performance:
In the Specify string settings area, select the applicable check box to:
Compress white space. Leading and trailing spaces are removed. Two or more consecutive interior spaces are compressed into one.
Ignore white space during matching. White spaces are removed from the input column, find, upper bound, and lower bound columns.
Ignore case. Case is ignored when the Clean transformer performs match processing.
Not copy a value if it matches a column in the rule table. A value is not copied if it matches a column in the rule table.
In the Escape character field, type an escape character. For example, you can specify \. You cannot use the characters % or _. An empty field does not suggest that a blank character is an escape character.
Click OK to save your changes and close the window.