Removing instances of one or more values that you specify

1On the Configuration tab of the cleanse asset, click Add Step.
2Select the Remove Values option.
3In the step properties pane, select Remove Custom Strings.
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. Removes any instance of the value that occurs in the input field. Can remove multiple instances of the same value in a field.
• - Start. Removes any instance of the value that is not preceded by another value in the input field.
• - End. Removes any instance of the value that is not followed by another value in the input field.
6Enter a string to search for and remove 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.
9Save the asset.