Manuals/calci/SEARCHB

Revision as of 17:55, 13 August 2018 by Devika (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

SEARCH

See Also

References