Manuals/calci/SEARCH

Revision as of 21:44, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''SEARCH'''</font></font></font><font color="#48...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

SEARCH(ftxt,wtxt,snum)

where ftxt   is the text that want to find and wxt is the text ithat want to search for ftxt and

snum   is the character number in wtxtt .


SEARCH identify one text string within a second text string, and brings the number of the starting position of the first text string from the first character of the second text string.

Note:SEARCH use the single-byte character set (SBCS


SEARCH


Let’s see an example in (Column1 Row 1)

C1R1 = Beautiful

I.e.= SEARCH(“f”,C1R1,3) is 7


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 Beautiful 7
Row2
Row3
Row4
Row5
Row6