Manuals/calci/FINDB - Revision history

Devika at 22:21, 9 August 2018

2018-08-09T22:21:00Z

Devika at 22:20, 9 August 2018

2018-08-09T22:20:20Z

Jayaram at 11:40, 14 March 2017

2017-03-14T11:40:24Z

Swapna at 19:09, 19 July 2015

2015-07-19T19:09:02Z

Swapna at 21:46, 11 February 2014

2014-02-11T21:46:16Z

Swapna at 21:43, 11 February 2014

2014-02-11T21:43:42Z

Show changes

MassBot1: Created page with "
'''FINDB'''(Find_text,Within_text,Start_num) where, '''Find_text''' is the text string to find. '''Within_..."

2013-10-25T02:35:34Z

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_..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''FINDB'''(Find_text,Within_text,Start_num)

where,

'''Find_text''' is the text string to find.

'''Within_text''' is the text containing the text you want to find.

'''Start_num''' specifies the character at which to start the search

</div>
----
<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>
----
<div id="7SpaceContent" class="zcontent" align="left">

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

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''FINDB (txt,txtst,n)'''</div><br/>
+<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.

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''FINDB (txt,txtst,n)'''</div><br/>
-*<math>txt</math> is the text you want to find.
+FINDB (FindText,WithinText,StartNumber)
-*<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.
+*<math>FindText</math> is the text you want to find.
 ==Description==
-FINDB (txt,txtst,n)
+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).
@@ Line 17: / Line 17: @@
 *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>FindText</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.
+*If <math>FindText</math> is not there in <math>WithinText</math>, Calci returns #ERROR message.
-*By default <math>n</math> is assumed to be 1 and is optional.
+*By default <math>StartNumber</math> is assumed to be 1 and is optional.
-*<math>n</math> should be an integer >gt; 0.
+*<math>StartNumber</math> should be an integer >gt; 0.
-*If <math>n</math> is greater than the length of <math>txtst</math>, Calci returns #ERROR message.
+*If <math>StartNumber</math> is greater than the length of <math>WithinText</math>, Calci returns #ERROR message.
 ==Examples==

← Older revision		Revision as of 11:40, 14 March 2017
Line 62:		Line 62:

	*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]		*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 19:09, 19 July 2015
Line 49:		Line 49:

	<font color ="Red">Need to give examples with characters/language supporting DBCS </font>		<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|4WhXx0KLF3c\|280\|center\|FIND}}

	==See Also==		==See Also==

@@ Line 47: / Line 47: @@
   =FINDB("T", A1) : Returns '''9''' as output.
   =FINDB("word", A2,5) : Returns '''5''' as output.
 ==See Also==