Excluding words from the index

You can select words for exclusion from the index.

You might want to exclude words because:

  • The words occur in all, or nearly all, records and contribute little to the search-ability of the database.

  • The words relate to administrative or other uses that you do not want to be visible to all users of text search.

You might also want to restore to the index some common words that SQL Server excludes by default, as being common words in the relevant language, but that have some special meaning in the databases.

These excluded words are for reference only. The words that are excluded by the server affect the results of Full-Text Search in iBase.

Select Tools > Search > Full-Text Search Indexing > Excluded Words to display the Excluded Words page:

Exclude Word

Add words to the list to exclude. Words are listed in alphabetical order.

Remove Selected

Removes all selected words from the list.

Import Words

Import a text file of the words that you have chosen to exclude:

  1. Enter a file name or browse for a file.

  2. Inspect the preview to check that the file contains the word you want to exclude and check that the message ERRORS OCCURRED AT does not appear.

  3. If you see this message, edit the file so that it meets the required format, save the file, and click Refresh.

  4. Turn on Merge with existing data if you want to keep any existing terms.

  5. Click Import.

Export Words

Creates a text file of the words that you have chosen to exclude.

When you have finished modifying the list of excluded words, click Apply to confirm your changes.

Format of the excluded word list

The excluded word list must be an unformatted text file containing one word per line with no blank lines. You cannot exclude words that are longer than 20 characters.

Double quotation marks are optional, but if they appear they must do so in pairs, one each at the start and end of a line. iBase Designer imports the word between the marks, ignoring the paired double quotation marks.

The words can be in any order or case (uppercase, lowercase or any mixture of the two), and may be duplicated within the file. iBase Designer sorts the list when importing, removes duplicates, and leaves the case unchanged.

If you see the message ERRORS OCCURRED AT, check the line number in the list to locate the errors. The most likely causes are:

  • A space character anywhere in the file, possibly before or after one of the words.

  • A completely blank line.

  • A mismatched or badly placed double quotation mark.