writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: − + − The first character in within_text is character number 1. If you omit <math>num</math>, it is assumed to be 1.+ − + − ==Description==+ + + + + + + + + +
no edit summary
==Description==
==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 <math>num</math> is character number 1. By default <math>num</math> 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 <math>text</math> is "" (NULL), FIND matches the first character in the search string.
It will return ERROR when:
1.<math>text</math> must not be wildcard characters.
2.If <math>text</math> is not there in <math>textstring</math>
3.If <math>num</math> is greater than the length of <math>textstring</math>.