Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SEARCHB'''(Text,Within_text, Start_num) where, '''Text''' - is the text string to extract. '''Within_te..."
<div id="6SpaceContent" class="zcontent" align="left">
'''SEARCHB'''(Text,Within_text, Start_num)
where,
'''Text''' - is the text string to extract.
'''Within_text'''- represents the text, find from Text.
'''Start_num''' - the character number in Within_text to start.
</div>
----
<div id="1SpaceContent" class="zcontent" align="left">
SEARCHB locate one text string within a second text string, and returns the number of the starting position of the first string from the first character of the second text string. SEARCHB is intended for use with languages that use the double-byte character set (DBCS).
</div>
----
<div id="7SpaceContent" class="zcontent" align="left">
If Start_num < 0, SEARCHB returns #ERROR.
If Start_num > length of Text, SEARCHB returns #ERROR.
If Within_text not found , it returns #ERROR.
If Start_num not defined then it returns the length of Text.
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
SEARCHB
</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">
Lets see an example in (Column1, Row2)
<nowiki>=SEARCHB("S", R1C1, 3)</nowiki>
SEARCHB returns 6.
Lets see an another example in (Column1,Row3)
<nowiki>=SEARCHB("I",R1C1)</nowiki>
SEARCHB returns 8.
Consider an example in (Column1, Row4)
<nowiki>=SEARCHB("b",R1C1)</nowiki>
SEARCHB returns #ERROR(TEXT not found).
</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|+ Default Calci
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | JOHN SMITH
| class=" " |
|
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | 6
|
|
|
|- class="odd"
| Row3
| class="sshl_f " | 8
|
|
|
|- class="even"
| Row4
| class="sshl_f" | #ERROR
|
|
|
|- class="odd"
| class=" " | Row5
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
|
|
|
|- class="even"
| Row6
|
|
|
|
|}
{| id="TABLE3_menu"
| align="right" | TABLE3
| <span align="left">[[Image:calci1.gif]]</span>
|
|
[[Image:bold.gif]]
|
[[Image:italic.gif]]
|
[[Image:normal.gif]]
|
[[Image:underline.gif]]
|
[[Image:border.gif]]
|
[[Image:numbers.gif]]
|
[[Image:sort.gif]]
|
[[Image:formatcells.gif]]
|
[[Image:graphs.gif]]
| $
|}
</div>
----
'''SEARCHB'''(Text,Within_text, Start_num)
where,
'''Text''' - is the text string to extract.
'''Within_text'''- represents the text, find from Text.
'''Start_num''' - the character number in Within_text to start.
</div>
----
<div id="1SpaceContent" class="zcontent" align="left">
SEARCHB locate one text string within a second text string, and returns the number of the starting position of the first string from the first character of the second text string. SEARCHB is intended for use with languages that use the double-byte character set (DBCS).
</div>
----
<div id="7SpaceContent" class="zcontent" align="left">
If Start_num < 0, SEARCHB returns #ERROR.
If Start_num > length of Text, SEARCHB returns #ERROR.
If Within_text not found , it returns #ERROR.
If Start_num not defined then it returns the length of Text.
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
SEARCHB
</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">
Lets see an example in (Column1, Row2)
<nowiki>=SEARCHB("S", R1C1, 3)</nowiki>
SEARCHB returns 6.
Lets see an another example in (Column1,Row3)
<nowiki>=SEARCHB("I",R1C1)</nowiki>
SEARCHB returns 8.
Consider an example in (Column1, Row4)
<nowiki>=SEARCHB("b",R1C1)</nowiki>
SEARCHB returns #ERROR(TEXT not found).
</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|+ Default Calci
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | JOHN SMITH
| class=" " |
|
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | 6
|
|
|
|- class="odd"
| Row3
| class="sshl_f " | 8
|
|
|
|- class="even"
| Row4
| class="sshl_f" | #ERROR
|
|
|
|- class="odd"
| class=" " | Row5
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
|
|
|
|- class="even"
| Row6
|
|
|
|
|}
{| id="TABLE3_menu"
| align="right" | TABLE3
| <span align="left">[[Image:calci1.gif]]</span>
|
|
[[Image:bold.gif]]
|
[[Image:italic.gif]]
|
[[Image:normal.gif]]
|
[[Image:underline.gif]]
|
[[Image:border.gif]]
|
[[Image:numbers.gif]]
|
[[Image:sort.gif]]
|
[[Image:formatcells.gif]]
|
[[Image:graphs.gif]]
| $
|}
</div>
----