writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + + + + − FINDB() is used to locate the starting position of a search text in another string. − + − + − e.g. FINDB("U","FUNCTION",1) returns ''2'' − Line 17:
Line 17: − + − + − + − + − +
no edit summary
<div style="font-size:30px">'''FINDB (txt,txtst,n)'''</div><br/>
<div style="font-size:30px">'''FINDB (txt,txtst,n)'''</div><br/>
*<math>txt</math> is the text you want to find.
FINDB (FindText,WithinText,StartNumber)
*<math>txtst</math> is the text or string that contains the text you want to find.
*<math>n</math> is the number to start the search.
*<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 (txt,txtst,n)
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).
*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>txt</math> is "" (NULL), FINDB matches with the first character in the search string.
*If <math>FindText</math> is "" (NULL), FINDB matches with the first character in the search string.
*If <math>txt</math> is not there in <math>txtst</math>, Calci returns #ERROR message.
*If <math>FindText</math> is not there in <math>WithinText</math>, Calci returns #ERROR message.
*By default <math>n</math> is assumed to be 1 and is optional.
*By default <math>StartNumber</math> is assumed to be 1 and is optional.
*<math>n</math> should be an integer >gt; 0.
*<math>StartNumber</math> should be an integer >gt; 0.
*If <math>n</math> is greater than the length of <math>txtst</math>, Calci returns #ERROR message.
*If <math>StartNumber</math> is greater than the length of <math>WithinText</math>, Calci returns #ERROR message.
==Examples==
==Examples==