Configuration Guide

10.4

Back Next

Editing Cleanse List Properties

New cleanse lists are empty lists. You need to edit the cleanse list to add match and output strings.

To edit your cleanse list to add match and output strings:

Start the Cleanse Functions tool.

Acquire a write lock.

Select the cleanse list that you want to configure.

The Cleanse Functions tool displays information about the cleanse list in the right pane.

Change the display name and description in the right pane, if you want, by clicking the

Edit

button next to a value that you want to change.

Click the

Details

tab.

The Cleanse Functions tool displays the details for the cleanse list.

Click the

Add

button in the right hand pane.

The Cleanse Functions tool displays the Output String dialog.

Specify a search string, an output string, a match type, and click

The search string is the input that you want to cleanse, resulting in the output string.

Informatica MDM Hub

will search through the strings in the order in which they are entered. The order in which you specify the items can therefore affect the results obtained. To learn more about the types of matches available, see Types of String Matches.

As soon as you add strings to a cleanse list, the cleanse list is saved.

The strings that you specified are shown in the Cleanse List Details section.

You can add and remove strings. You can also move string forward or backward in the cleanse list, which affects their order in run-time execution sequence and, therefore, the results obtained.

You can also specify the “Default value” for every input string that does not match any of the search strings.

If you do not specify a default value, every input string that does not match a search string is passed to the output string with no changes.

Configuring Cleanse Lists

Types of String Matches

Importing Match Strings

Importing Match Output Strings

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal