Revision as of 12:48, 13 May 2015

SEARCHB(ftext, otext, snum)

where

$ftext$ is the text to search in original string,
$otext$ is the original string from which mentioned text is to be searched, and
$snum$ is an optional argument that specifies the character position to start the search.

SEARCHB() identifies the occurrence of specified text string from the original string and returns the starting position of the matched string.

For Example,

SEARCHB("C", "WELCOME",1) returns 4

SEARCHB function can be used to find text within a text. SEARCHB counts 2 bytes per character. SEARCHB is intended for languages that use double-byte character set (DBCS).
$otext$ can be any string containing characters, numbers, symbols, blank spaces etc.
$ftext$ and $otext$ when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
Argument $snum$ is optional. If omitted, Calci assumes to be 1.
$snum$ should be an integer > 0, else Calci displays #NULL error message.
If $snum$ > 'length of text', Calci displays #N/A error message.
If string specified in $otext$ is not a part of the reference string $txt$ , Calci returns #N/A error string.
SEARCHB function is not case sensitive.

=SEARCHB("I", A1) : Returns 8 as output.
=SEARCHB(">", A2) : Returns 3 as output.

Need to give examples with characters/language supporting DBCS

@@ Line 51: / Line 51: @@
 <font color ="Red">Need to give examples with characters/language supporting DBCS </font>
+==Related Videos==
+{{#ev:youtube|x8zquflNpnM|280|center|SEARCH}}
 == See Also ==