Manuals/calci/SEARCH
Jump to navigation
Jump to search
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 |
