KEYWORDSI()

Syntax

Sorted_List as C = KEYWORDSI( Character_Expression as C )

Argument

Description

Character_Expression

A string expression containing words separated by spaces.

Description

KEYWORDSI() returns a sorted list of all of the unique words in Character_Expression. This function is typically used to build an index for full text searching. When you build full text indexes on memo fields and other long character fields, Alpha Five can find a word anywhere within long memos and character fields very quickly, using Lightning Query Optimization. Case insensitive.

Supported By

Alpha Five Version 5 and Above

Example

? keywords("now is the time for all Good Men")

= "all for Good is Men now the time"

? keywords("now is the time for for for all Good Men")

= "all for Good is Men now the time", because only unique words are returned.

See Also

Character Extraction Functions, Character Sort Functions