Manuals/calci/SEARCHB

SEARCHB (Find_Text,Within_Text,Start_Num)

where

• $Find-Text$ is the text to search in original string,
• $Within-Text$ is the original string from which mentioned text is to be searched, and
• $Start-Num$ 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).
• $Within-Text$ can be any string containing characters, numbers, symbols, blank spaces etc.
• $Find-Text$ and $Within-Text$ when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
• Argument $Start-Num$ is optional. If omitted, Calci assumes to be 1.
• $Start-Num$ should be an integer > 0, else Calci displays #NULL error message.
• If $Start-Num$ > 'length of text', Calci displays #N/A error message.
• If string specified in $Within-Text$ is not a part of the reference string $Find-Text$, 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

SEARCH

See Also

• SEARCH
• REPLACEB

References

• Find and Replace

• List of Main Z Functions

• Z3 home