Difference between revisions of "Manuals/calci/SEARCHB"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
=SEARCHB(ftext, otext, snum)=
+
<div style="font-size:30px">'''SEARCHB (Find_Text,Within_Text,Start_Num) '''</div><br/>
  
 
where  
 
where  
−
*<math>ftext</math> is the text to search in original string,
+
*<math>Find-Text</math> is the text to search in original string,
−
*<math>otext</math> is the original string from which mentioned text is to be searched, and
+
*<math>Within-Text</math> is the original string from which mentioned text is to be searched, and
−
*<math>snum</math> is an optional argument that specifies the character position to start the search.
+
*<math>Start-Num</math> 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).
−
SEARCHB() identifies the occurrence of specified text string from the original string and returns the starting position of the matched string.
 
  
 
== Description ==
 
== Description ==
  
−
SEARCHB(ftext, otext, snum)
+
SEARCHB (Find_Text,Within_Text,Start_Num)
−
 
 
 
For Example,
 
For Example,
  
Line 17: Line 15:
  
 
*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).
 
*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).
−
*<math>otext</math> can be any string containing characters, numbers, symbols, blank spaces etc.
+
*<math>Within-Text</math> can be any string containing characters, numbers, symbols, blank spaces etc.
−
*<math>ftext</math> and <math>otext</math> when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
+
*<math>Find-Text</math> and <math>Within-Text</math> when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
−
*Argument <math>snum</math> is optional. If omitted, Calci assumes to be 1.
+
*Argument <math>Start-Num</math> is optional. If omitted, Calci assumes to be 1.
−
*<math>snum</math> should be an integer &gt; 0, else Calci displays #NULL error message.
+
*<math>Start-Num</math> should be an integer &gt; 0, else Calci displays #NULL error message.
−
*If <math>snum</math> &gt; 'length of text', Calci displays #N/A error message.
+
*If <math>Start-Num</math> &gt; 'length of text', Calci displays #N/A error message.
−
*If string specified in <math>otext</math> is not a part of the reference string <math>txt</math>, Calci returns #N/A error string.
+
*If string specified in <math>Within-Text</math> is not a part of the reference string <math>Find-Text</math>, Calci returns #N/A error string.
 
*SEARCHB function is not case sensitive.
 
*SEARCHB function is not case sensitive.
  
Line 63: Line 61:
  
 
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]
 
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:55, 13 August 2018

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


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/SEARCHB&oldid=211067"