Difference between revisions of "Manuals/calci/FIND"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''FIND ( | + | <div style="font-size:30px">'''FIND (txt,txtst,n)'''</div><br/> |
| − | *<math> | + | *<math>txt</math> is the text you want to find. |
| − | *<math> | + | *<math>txtst</math> is the text or string that contains the text you want to find. |
| − | *<math> | + | *<math>n</math> is the number to start the search. |
==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. | *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> | + | *First character in <math>n</math> is character number 1. By default <math>n</math> is assumed to be 1 and is optional. |
*FIND is used with languages that use the single-byte character set(SBCS). | *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). | *FINDB is used with languages that use the double-byte character set (DBCS). | ||
| Line 13: | Line 13: | ||
#<math>FINDB</math> counts double-byte character as 2. | #<math>FINDB</math> counts double-byte character as 2. | ||
*<math>FIND</math> and <math>FINDB</math> 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> | + | *If <math>txt</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> | + | 1.<math>txt</math> must not be wildcard characters. |
| − | 2.If <math> | + | 2.If <math>txt</math> is not there in <math>textstring</math> |
| − | 3.If <math> | + | 3.If <math>n</math> is greater than the length of <math>txtst</math>. |
==Examples== | ==Examples== | ||
Revision as of 00:00, 18 December 2013
FIND (txt,txtst,n)
- 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 .
3.If