repfind

Syntax

stat=REPFIND(tag,position,text,type_search)

Arguments

stat, position: integer

tag: database variable

text: text

type_search: integer, see table below

Meaning

Searches the occurrences of tag, starting at occurrence position, for text text. The text can only be found if it equals the complete contents of an occurrence. You cannot search truncated. The function returns the number of the occurrence in which text was found. If text has not been found, the function will return a 0.

With type_search you determine the type of data that you want to search on:

Searching on the neutral value in an enumerative field is possible too.

Example

repfind(au, 3, 'Bloggs, J.', 0)

Result

The text Bloggs, J. is sought from the third occurrence of tag au. Names like "Bloggs, j." or "Blóggs, J." will not be retrieved.