SEARCH & LOAD Start List

The SEARCH & LOAD Start List will be applied during both searching and loading.

Use the Start List of the Translate Table to define only specific words to be indexed. The Start List provides a simple means of categorizing data. If a Start List exists, only words found within the Start List are indexed. All other words are discarded. However, it is not the word itself that is indexed. Instead, there is a replacement word associated with the start word. It is that word which is indexed without any further replacement or stemming.

The major use of a Start List is in categorizing data. A category is created by associating a number of individual start words with the same replacement word. Once the desired number of categories have been created within the Start List, the list can be used with an index created over the data to categorize it for searching or histogramming.

The Start List is composed of two columns of words. The words in the first column represents the Pattern, the words to be found in the data, and the second column represents the Replacement, or the words to be indexed in place of their corresponding Pattern.

Example Start List to categorize records by make of automobile

Pattern

Replacement

626

mazda

camaro

chevrolet

cavalier

chevrolet

chevrolet

chevrolet

chevy

chevrolet

cobra

ford

corvette

chevrolet

cougar

mercury

firebird

pontiac

focus

ford

ford

ford

galaxy

ford

impala

chevrolet

malibu

chevrolet

maverick

ford

mazda

mazda

mercury

mercury

miata

mazda

millenia

mazda

mpv

mazda

mustang

ford

pontiac

pontiac

prizm

ford

sable

mercury

thunderbird

ford

taurus

ford

venture

chevrolet

villager

mercury

windstar

ford

zx2

ford