Cleanse assets

Back Next

Replacing instances of one or more values that you specify

You can configure a step to replace instances of one or more values that you specify with a single new value.

On the

Configuration

tab of the cleanse asset, click

Add Step

Select the

Replace Values

option.

In the step properties pane, select

Replace Custom Strings with a New Data Value

Verify 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.

Set 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.

Enter a value to search for and replace in the

Custom Strings

field.

The search operation is case-sensitive.

Add the string to the list of strings to search for.

Optionally, add one or more additional strings to the list.

Enter the replacement value in the

New Data Value

field.

Save the asset.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.