Manuals/calci/FIND
FIND (text,textstring,num)
- is the text you want to find.
- is the text or string that contains the text you want to find.
- is the number to start the search.
Description
- FIND is used to locate the starting position of a search text in another string. ie, it will search the text inside another string and will return the starting position of the text inside the string.
- First character in is character number 1. By default is assumed to be 1 and is optional.
- FIND is used with languages that use the single-byte character set(SBCS).
- FINDB is used with languages that use the double-byte character set (DBCS).
- The default language of your computer will result in the return value
- FIND counts each character. It wont depend on default language setting.
- FINDB counts double-byte character as 2.
- FIND and FINDB are case sensitive. It won't allow wildcard characters.
- If is "" (NULL), FIND matches with the first character in the search string.
It will return ERROR when:
1. must not be wildcard characters. 2.If is not there in 3.If is greater than the length of .