Shared Definition Lists
- Add
-
Click Add
to add a new string substitution pair to the list of substitutions.
- Delete
-
Click Delete
to delete the selected item in the substitution list.
- Modify
-
Click Modify to modify the selected item in the substitution list with the values from the two edit fields.
- Import
-
Click Import to import a file that contains a list of string substitutions. For the import you can either add the string substitutions to your current list of substitutions or replace them by the imported list. You can import string substitutions that are exported from a Tungsten Search and Matching Server database as well as from a Tungsten Transformation Modules Project Builder or a Tungsten TotalAgility Transformation Designer database.
- Export
-
Click Export to export your string substitution pairs to a text file. You can then import the string substitutions to be used for other Tungsten Search and Matching Server or Project Builder databases.
- Characters to ignore
-
Type a list of characters into this field to filter unwanted characters from the input record. When you want to use a field delimiter that may also be a character in the input, such as a comma (,), then you have to use quotes (") to identify the input strings. However, you probably do not want to retain those quotation marks as part of the final results.
If you define the quotes as characters to ignore, they are removed. To define a tab or space as characters to ignore, select the corresponding check box.The value for this setting is set to ."'! (period, quotation mark, single quotation mark, and an exclamation point) by default.
- Space
-
Select this checkbox if you want to ignore a Space character in addition to the characters specified in the Characters to ignore setting.
- Word separation characters
-
If fields in the database contain compound words, common characters can be specified so that each part of the compound word is searched and evaluated separately. The value for this setting is set to " -," (space, hyphen, comma) by default.
For example, using the default settings, the compound word "Diagon-Alley," is treated as two words, "diagon" and "alley" that are searched and evaluated separately.
The separation characters must correspond to the delimiter characters that are defined for OCR.
- Tab
-
Select this checkbox if you want to use a Tab as a word separation character in addition to the characters specified in the Word separation characters setting.
- Space
-
Select this checkbox if you want to use a Space as a word separation character in addition to the characters specified in the Word separation characters setting.
- Field delimiter
-
Type values into this field to specify what characters separate the import file content into individual fields. The value for this setting is set to ; (semicolon) by default.
- Tab
-
Select this checkbox to use a Tab as a delimiter in addition to the characters specified in the Field delimiter setting.
- Ignore Case
-
Select this option to convert all search and lookup strings to lower case, effectively ignoring case. This is the default setting.