Difference between revisions of "Manuals/calci/FIND"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
*FINDB is used with languages that use the double-byte character set (DBCS). | *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 | *The default language of your computer will result in the return value | ||
| − | #FIND counts each character. It wont depend on default language setting. | + | #<math>FIND</math> counts each character. It wont depend on default language setting. |
| − | # FINDB counts double-byte character as 2. | + | #<math>FINDB</math> counts double-byte character as 2. |
| − | *FIND and FINDB are case sensitive. It won't allow wildcard characters. | + | *<math>FIND</math> and <math>FINDB</math> are case sensitive. It won't allow wildcard characters. |
*If <math>text</math> is "" (NULL), FIND matches with 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: | ||
Revision as of 05:24, 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
- counts each character. It wont depend on default language setting.
- counts double-byte character as 2.
counts each character. It wont depend on default language setting.
counts double-byte character as 2.- and 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 .