Manuals/calci/FINDB

FINDB (txt,txtst,n)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle txt} is the text you want to find.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle txtst} is the text or string that contains the text you want to find.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is the number to start the search.

FINDB() is used to locate the starting position of a search text in another string.

Description

FINDB (txt,txtst,n)

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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle txt} is "" (NULL), FINDB matches with the first character in the search string.
• If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle txt} is not there in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle txtst} , Calci returns #ERROR message.
• By default Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is assumed to be 1 and is optional.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} should be an integer >gt; 0.
• If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is greater than the length of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle txtst} , 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

FIND

See Also

• FIND
• SEARCHB

References

• Find and Replace