Difference between revisions of "Manuals/calci/SEARCHB"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =SEARCHB( | + | <div style="font-size:30px">'''SEARCHB (Find_Text,Within_Text,Start_Num) '''</div><br/> |
where | where | ||
| − | *<math> | + | *<math>Find-Text</math> is the text to search in original string, |
| − | *<math> | + | *<math>Within-Text</math> is the original string from which mentioned text is to be searched, and |
| − | *<math> | + | *<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() | ||
== Description == | == Description == | ||
| − | SEARCHB( | + | 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> | + | *<math>Within-Text</math> can be any string containing characters, numbers, symbols, blank spaces etc. |
| − | *<math> | + | *<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> | + | *Argument <math>Start-Num</math> is optional. If omitted, Calci assumes to be 1. |
| − | *<math> | + | *<math>Start-Num</math> should be an integer > 0, else Calci displays #NULL error message. |
| − | *If <math> | + | *If <math>Start-Num</math> > 'length of text', Calci displays #N/A error message. |
| − | *If string specified in <math> | + | *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. | ||
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).
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.
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