Difference between revisions of "Manuals/calci/FINDB"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FINDB'''(Find_text,Within_text,Start_num) where, '''Find_text'''  is the text string to find. '''Within_...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''FINDB (txt,txtst,n)'''</div><br/>
 +
*<math>txt</math> is the text you want to find.
 +
*<math>txtst</math> is the text or string that contains the text you want to find.
 +
*<math>n</math> is the number to start the search.
  
−
'''FINDB'''(Find_text,Within_text,Start_num)
+
FINDB() is used to locate the starting position of a search text in another string.
  
−
where,
+
==Description==
  
−
'''Find_text'''  is the text string to find.
+
FINDB (txt,txtst,n)
  
−
'''Within_text'''  is the text containing the text you want to find.
+
e.g. FINDB("U","FUNCTION",1) returns ''2''
  
−
'''Start_num'''   specifies the character at which to start the search
+
*FINDB searches the text inside another string and returns the starting position of the text inside the string.
 +
*FINDB is used with languages that use the double-byte character set (DBCS).
 +
*The default language of your computer will result in the return value
 +
*FINDB counts double-byte character as 2.
 +
*FIND and FINDB are case sensitive. It won't allow wildcard characters.
 +
*If <math>txt</math> is "" (NULL), FINDB matches with the first character in the search string.
 +
*If <math>txt</math> is not there in <math>txtst</math>, Calci returns #ERROR message.
 +
*By default <math>n</math> is assumed to be 1 and is optional.
 +
*<math>n</math> should be an integer >gt; 0.
 +
*If <math>n</math> is greater than the length of <math>txtst</math>, Calci returns #ERROR message.
  
−
</div>
+
==Examples==
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
FINDB locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. FINDB is intended for use with languages that use the double-byte character set (DBCS).
+
<div id="6SpaceContent" class="zcontent" align="left">
  
−
</div>
+
{| id="TABLE3" class="SpreadSheet blue"
−
----
+
|- class="even"
−
<div id="7SpaceContent" class="zcontent" align="left">
+
| class="ssh1_f" |JOHN SMITH
 +
| class=" " |
 +
| class=" " |
  
−
If find_text is "" (empty text), FIND matches the first character in the search string (that is, the character numbered start_num or 1).
+
|- class="odd"
 +
| class="ssh1_f" |Password
 +
| class="  " |
 +
| class="  " |
  
−
If Number_chars &gt; length of text, it returns all of text.
+
|- class="even"
 +
| class="ssh1_f" |
 +
| class="  " |
 +
| class="  " |
  
−
If find_text does not appear in within_text, FINDB return the #ERROR  value.
+
|}
  
−
If start_num is not greater than zero, FINDB return the #ERROR value.
+
=FINDB("T", A1) : Returns '''9''' as output.
 +
=FINDB("word", A2,5) : Returns '''5''' as output.
  
−
If start_num is greater than the length of within_text, FINDB return the #ERROR value
+
==See Also==
  
−
If you omit start_num, it is assumed to be 1.
+
*[[Manuals/calci/FIND | FIND ]]
 +
*[[Manuals/calci/SEARCHB | SEARCHB ]]
  
−
</div>
+
==References==
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
−
 
 
−
FINDB
 
−
 
 
−
</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example in (Column3Row1)
 
−
 
 
−
<nowiki>=FINDB(R1C1,R1C2,1)</nowiki>
 
−
 
 
−
FINDB("smith","th",1) returns 4
 
−
 
 
−
Consider another example in (Column3Row2)
 
−
 
 
−
<nowiki>=FINDB(R1C1,R1C2,7)</nowiki>
 
−
 
 
−
FINDB("smith","th",7) returns #ERROR
 
−
 
 
−
</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="5SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|+ Default Calci
 
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | smith
 
−
| class=" " | th
 
−
| class="sshl_f" | 4
 
−
| class=" " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="  " |
 
−
| class=" " |
 
−
| class="sshl_f" | #ERROR
 
−
| class="  " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="                                                                                                                  " |
 
−
|
 
−
| class=" sshl_f SelectTD1 ChangeBGColor SelectTD1" |
 
−
<div id="5Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="5Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="5Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" sshl_f" |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
|
 
−
| class="  " |
 
−
| class="  " |
 
−
| class="  " |
 
−
|- class="even"
 
−
| Row6
 
−
| class="  " |
 
−
|
 
−
|
 
−
| class="  " |
 
−
|}
 
−
 
 
−
{| 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>
+
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]
−
----
 

Revision as of 15:43, 11 February 2014

FINDB (txt,txtst,n)


  • is the text you want to find.
  • is the text or string that contains the text you want to find.
  • is the number to start the search.

FINDB() is used to locate the starting position of a search text in another string.

Description

FINDB (txt,txtst,n)

e.g. FINDB("U","FUNCTION",1) returns 2

  • FINDB searches the text inside another string and returns the starting position of the text inside the string.
  • FINDB is used with languages that use the double-byte character set (DBCS).
  • The default language of your computer will result in the return value
  • FINDB counts double-byte character as 2.
  • FIND and FINDB are case sensitive. It won't allow wildcard characters.
  • If is "" (NULL), FINDB matches with the first character in the search string.
  • If is not there in , Calci returns #ERROR message.
  • By default is assumed to be 1 and is optional.
  • should be an integer >gt; 0.
  • If is greater than the length of , Calci returns #ERROR message.

Examples

JOHN SMITH
Password 
=FINDB("T", A1) : Returns 9 as output.
=FINDB("word", A2,5) : Returns 5 as output.

See Also

References

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