Replacing instances of one or more values that you specify

1On the Configuration tab of the cleanse asset, click Add Step.
2Select the Replace Values option.
3In the step properties pane, select Replace Custom Strings with a New Data Value.
4Verify the delimiter that the mapping will use to recognize discrete values in the input field. You can specify one or more delimiters.
The input delimiter determines how the mapping reads the input data when you select the Start or End option as the scope.
5Set the scope for the search operation.
You can set the following options:
• - Anywhere. Replaces any instance of the value that occurs in the input field. Can replace multiple instances of the same value in a field.
• - Start. Replaces any instance of the value that is not preceded by another value in the input field.
• - End. Replaces any instance of the value that is not followed by another value in the input field.
6Enter a value to search for and replace in the Custom Strings field.
Note:
The search operation is case-sensitive.
7Add the string to the list of strings to search for.
8Optionally, add one or more additional strings to the list.
9Enter the replacement value in the New Data Value field.
10Save the asset.