Difference between revisions of "Manuals/calci/FIND"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
# FINDB counts double-byte character as 2. | # FINDB counts double-byte character as 2. | ||
*FIND and FINDB are case sensitive. It won't allow wildcard characters. | *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. | + | *If <math>text</math> is "" (NULL), FIND matches with the first character in the search string. |
It will return ERROR when: | It will return ERROR when: | ||
1.<math>text</math> must not be wildcard characters. | 1.<math>text</math> must not be wildcard characters. | ||
2.If <math>text</math> is not there in <math>textstring</math> | 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>. | 3.If <math>num</math> is greater than the length of <math>textstring</math>. | ||
| − | |||
==Examples== | ==Examples== | ||
Revision as of 05:22, 5 December 2013
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.
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 .