Difference between revisions of "Manuals/calci/FINDB"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''FINDB (txt,txtst,n)'''</div><br/> | <div style="font-size:30px">'''FINDB (txt,txtst,n)'''</div><br/> | ||
| − | *<math> | + | FINDB (FindText,WithinText,StartNumber) |
| − | *<math> | + | |
| − | *<math> | + | *<math>FindText</math> is the text you want to find. |
| + | *<math>WithinText</math> is the text or string that contains the text you want to find. | ||
| + | *<math>StartNumber</math> is the number to start the search. | ||
| + | **FINDB() Finds one text value within another (case-sensitive).FINDB is intended for use with languages that use the double-byte character set (DBCS). | ||
| − | |||
==Description== | ==Description== | ||
| − | FINDB ( | + | FINDB (FindText,WithinText,StartNumber) |
| − | + | *E.g. FINDB("U","FUNCTION",1) returns ''2'' | |
| − | |||
| − | |||
*FINDB searches the text inside another string and returns the starting position of the text inside the string. | *FINDB searches the text inside another string and returns the starting position of the text inside the string. | ||
*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 17: | Line 17: | ||
*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> | + | *If <math>FindText</math> is "" (NULL), FINDB matches with the first character in the search string. |
| − | *If <math> | + | *If <math>FindText</math> is not there in <math>WithinText</math>, Calci returns #ERROR message. |
| − | *By default <math> | + | *By default <math>StartNumber</math> is assumed to be 1 and is optional. |
| − | *<math> | + | *<math>StartNumber</math> should be an integer >gt; 0. |
| − | *If <math> | + | *If <math>StartNumber</math> is greater than the length of <math>WithinText</math>, Calci returns #ERROR message. |
==Examples== | ==Examples== | ||
Revision as of 16:20, 9 August 2018
FINDB (txt,txtst,n)
FINDB (FindText,WithinText,StartNumber)
- 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.
- FINDB() Finds one text value within another (case-sensitive).FINDB is intended for use with languages that use the double-byte character set (DBCS).
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
FINDB (FindText,WithinText,StartNumber)
- E.g. FINDB("U","FUNCTION",1) returns 2
- FINDB searches the text inside another string and returns the starting position of the text inside the string.
- 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
- FINDB counts double-byte character as 2.
- FIND and FINDB are case sensitive. It won't allow wildcard characters.
- If is "" (NULL), FINDB matches with the first character in the search string.
- If is not there in , Calci returns #ERROR message.
- By default is assumed to be 1 and is optional.
- should be an integer >gt; 0.
- If is greater than the length of , Calci returns #ERROR message.
Examples
| JOHN SMITH | ||
| Password | ||
=FINDB("T", A1) : Returns 9 as output.
=FINDB("word", A2,5) : Returns 5 as output.
Need to give examples with characters/language supporting DBCS
Related Videos
See Also
References