Manuals/calci/SEARCH

SEARCH (Find_Text,Within_Text,Start_Num)

where

• $Find-Text$ is the text to search in original string,
• $Within-Text$ is the original string from which mentioned text is to be searched, and
• $Start-Num$ is an optional argument that specifies the character position to start the search.
  • SEARCH() identifies the occurrence of specified text string from the original string and returns the starting position of the matched string.

Description

SEARCH (Find_Text,Within_Text,Start_Num) For Example,

SEARCH("COME", "WELCOME",1) returns 4

• SEARCH function can be used to find text within a text. SEARCH counts 1 byte per character. SEARCH works with the languages that use 'Single Byte Character Set' (SBCS).
• $Within-Text$ can be any string containing characters, numbers, symbols, blank spaces etc.
• $Find-Text$ and $Within-Text$ when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
• Argument $Start-Num$ is optional. If omitted, Calci assumes to be 1.
• $Start-Num$ should be an integer > 0, else Calci displays #NULL error message.
• If $Start-Num$ > 'length of text', Calci displays #N/A error message.
• If string specified in $Find-Text$ is not a part of the reference string $Within-Text$, Calci returns #N/A error string.
• SEARCH function is not case sensitive.

Examples

SEARCH
Happy New Year!!!

=SEARCH("A", A1) : Returns 3 as output.
=SEARCH("New", A2) : Returns 7 as output. Space character is also counted.
=SEARCH("Year",A2,6) : Search is started from 6th position. Returns 11 as output. 
Space character is also counted.

Related Videos

SEARCH

See Also

• SEARCHB
• REPLACE
• REPT

References

• Find and Replace

• List of Main Z Functions

• Z3 home