writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − + − + − + − + − − + − Line 17:
Line 16: − + − + − + − + − + − +
no edit summary
=SEARCHB(ftext, otext, snum)=
=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,
*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 > 0, else Calci displays #NULL error message.
*<math>Start-Num</math> should be an integer > 0, else Calci displays #NULL error message.
*If <math>snum</math> > 'length of text', Calci displays #N/A error message.
*If <math>Start-Num</math> > '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.