SEARCHB(ftext, otext, snum)
SEARCHB (Find_Text,Within_Text,Start_Num)
where
- is the text to search in original string,
- is the original string from which mentioned text is to be searched, and
- is an optional argument that specifies the character position to start the search.
- SEARCHB(), finds one text value within another.SEARCHB is intended for use with languages that use the double-byte character set (DBCS).
Description
SEARCHB (Find_Text,Within_Text,Start_Num) 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).
- can be any string containing characters, numbers, symbols, blank spaces etc.
- and when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
- Argument is optional. If omitted, Calci assumes to be 1.
- should be an integer > 0, else Calci displays #NULL error message.
- If > 'length of text', Calci displays #N/A error message.
- If string specified in is not a part of the reference string , Calci returns #N/A error string.
- SEARCHB function is not case sensitive.
Examples
JOHN SMITH | ||
<#>!!! | ||
=SEARCHB("I", A1) : Returns 8 as output. =SEARCHB(">", A2) : Returns 3 as output.
Need to give examples with characters/language supporting DBCS
Related Videos
See Also
References