Shared Database Definition
- Ignore Case
-
Select this setting to convert all search and lookup strings to lower case, effectively ignoring case. (Default: Selected)
- Field delimiter
-
Type values into this field to specify what characters separate the import file content into individual fields. Default: ; (semicolon))
- Tab
-
Select this checkbox to use a Tab as a delimiter in addition to the characters specified in the Field delimiter 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. (Default: -, (space, hyphen, comma))
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.
- 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. (Default: ."'! (period, quotation mark, single quotation mark, and an exclamation point))
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.
- Space
-
Select this checkbox if you want to ignore a Space character in addition to the characters specified in the Characters to ignore setting.
- String Substitution