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:

Type_search

Meaning

0

Search case- and accent sensitive on text

1

Search on number

2

Search on date

256

Search case insensitive on text

1024

Search accent insensitive on text

1280

Search case- and accent insensitive on text

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.