Configuration Guide

10.4

Back Next

Importing Match Strings

To import match strings (such as a file or a database table):

Click the

button in the right hand pane.

The Import Match Strings wizard opens.

Specify the connection properties for the source of the data and click

The Cleanse Functions tool displays a list of tables available for import.

Select the table you want to import and click

The Cleanse Functions tool displays a list of columns available for import.

Click the columns you want to import and click

The Cleanse Functions tool displays a list of match strings available for import.

You can import the records of the sample data either as phrases (one entry for each record) or as words (one entry for each word in each record). Choose whether to import the match strings as words or phrases and then click

Finish

The Cleanse List Details box is now populated with data from the specified source.

The imported match strings are not part of the match list. To add them to the match list, you need to move them to the Search Strings on the right hand side.

To add match strings to the match list with the match string value in both the Search String and Output String, select the strings in the Match Strings list, and click the

button.

If you add match strings to the match list with an Output String value that you want to define, click the record you added and specify a new Search and Output String.

To add all Match Strings to the match list, click the

button.