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.