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_...")
 
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''FINDB (FindText,WithinText,StartNumber) '''</div><br/>
 +
*<math>FindText</math> is the text you want to find.
 +
*<math>WithinText</math> is the text or string that contains the text you want to find.
 +
*<math>StartNumber</math> is the number to start the search.
 +
**FINDB() Finds one text value within another (case-sensitive).FINDB is intended for use with languages that use the double-byte character set (DBCS).
  
−
'''FINDB'''(Find_text,Within_text,Start_num)
 
  
−
where,
+
==Description==
  
−
'''Find_text'''  is the text string to find.
+
FINDB (FindText,WithinText,StartNumber)
 +
*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 <math>FindText</math> is "" (NULL), FINDB matches with the first character in the search string.
 +
*If <math>FindText</math> is not there in <math>WithinText</math>, Calci returns #ERROR message.
 +
*By default <math>StartNumber</math> is assumed to be 1 and is optional.
 +
*<math>StartNumber</math> should be an integer >gt; 0.
 +
*If <math>StartNumber</math> is greater than the length of <math>WithinText</math>, Calci returns #ERROR message.
  
−
'''Within_text'''  is the text containing the text you want to find.
+
==Examples==
  
−
'''Start_num'''   specifies the character at which to start the search
+
<div id="6SpaceContent" class="zcontent" align="left">
  
−
</div>
+
{| id="TABLE3" class="SpreadSheet blue"
−
----
+
|- class="even"
−
<div id="1SpaceContent" class="zcontent" align="left">
+
| class="ssh1_f" |JOHN SMITH
 +
| class=" " |
 +
| class=" " |
  
−
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).
+
|- class="odd"
 +
| class="ssh1_f" |Password
 +
| class="  " |
 +
| class="  " |
  
−
</div>
+
|- class="even"
−
----
+
| class="ssh1_f" |
−
<div id="7SpaceContent" class="zcontent" align="left">
+
| 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).
+
|}
−
 
 
−
If Number_chars &gt; length of text, it returns all of text.
 
−
 
 
−
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.
 
−
 
 
−
If start_num is greater than the length of within_text, FINDB return the #ERROR value
 
−
 
 
−
If you omit start_num, it is assumed to be 1.
 
  
−
</div>
+
=FINDB("T", A1) : Returns '''9''' as output.
−
----
+
=FINDB("word", A2,5) : Returns '''5''' as output.
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
FINDB
+
<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
  
−
</div></div>
+
==Related Videos==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column3Row1)
+
{{#ev:youtube|4WhXx0KLF3c|280|center|FIND}}
  
−
<nowiki>=FINDB(R1C1,R1C2,1)</nowiki>
+
==See Also==
  
−
FINDB("smith","th",1) returns 4
+
*[[Manuals/calci/FIND | FIND ]]
 +
*[[Manuals/calci/SEARCHB | SEARCHB ]]
  
−
Consider another example in (Column3Row2)
+
==References==
  
−
<nowiki>=FINDB(R1C1,R1C2,7)</nowiki>
+
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]
  
−
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"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|+ 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>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 16:21, 9 August 2018

FINDB (FindText,WithinText,StartNumber)


  • 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() Finds one text value within another (case-sensitive).FINDB is intended for use with languages that use the double-byte character set (DBCS).


Description

FINDB (FindText,WithinText,StartNumber)

  • 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.

Need to give examples with characters/language supporting DBCS

Related Videos

FIND

See Also

References


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