FIND

WORDPOS is the preferred built-in function for this type of word search. See page WORDPOS (Word Position) for a complete description.

Read syntax diagramSkip visual syntax diagram
>>-FIND--(--string--,--phrase--)-------------------------------><

returns the word number of the first word of phrase found in string or returns 0 if phrase is not found or if there are no words in phrase. The phrase is a sequence of blank-delimited words. Multiple blanks between words in phrase or string are treated as a single blank for the comparison.
Here are some examples:
FIND('now is the time','is the time')    ->    2
FIND('now is  the time','is    the')     ->    2
FIND('now is  the time','is  time ')     ->    0


fnd.html | Timestamp icon Last updated: Monday, 5 June 2017