Difference between revisions of "Manuals/calci/SEARCH"
Jump to navigation
Jump to search
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =SEARCH( | + | <div style="font-size:30px">'''SEARCH (Find_Text,Within_Text,Start_Num) '''</div><br/> |
| − | |||
where | where | ||
| − | *<math> | + | *<math>Find-Text</math> is the text to search in original string, |
| − | *<math> | + | *<math>Within-Text</math> is the original string from which mentioned text is to be searched, and |
| − | *<math> | + | *<math>Start-Num</math> 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. | |
| − | SEARCH() identifies the occurrence of specified text string from the original string and returns the starting position of the matched string. | ||
== Description == | == Description == | ||
| − | SEARCH( | + | SEARCH (Find_Text,Within_Text,Start_Num) |
| − | |||
For Example, | For Example, | ||
| Line 17: | Line 14: | ||
*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). | *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). | ||
| − | *<math> | + | *<math>Within-Text</math> can be any string containing characters, numbers, symbols, blank spaces etc. |
| − | *<math> | + | *<math>Find-Text</math> and <math>Within-Text</math> when directly entered in the command, should be enclosed in double quotes (e.g. "Name"). |
| − | *Argument <math> | + | *Argument <math>Start-Num</math> is optional. If omitted, Calci assumes to be 1. |
| − | *<math> | + | *<math>Start-Num</math> should be an integer > 0, else Calci displays #NULL error message. |
| − | *If <math> | + | *If <math>Start-Num</math> > 'length of text', Calci displays #N/A error message. |
| − | *If string specified in <math> | + | *If string specified in <math>Find-Text</math> is not a part of the reference string <math>Within-Text</math>, Calci returns #N/A error string. |
*SEARCH function is not case sensitive. | *SEARCH function is not case sensitive. | ||
| Line 50: | Line 47: | ||
=SEARCH("New", A2) : Returns '''7''' as output. Space character is also counted. | =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. <br />Space character is also counted. | =SEARCH("Year",A2,6) : Search is started from 6th position. Returns '''11''' as output. <br />Space character is also counted. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|x8zquflNpnM|280|center|SEARCH}} | ||
== See Also == | == See Also == | ||
| + | *[[Manuals/calci/SEARCHB | SEARCHB]] | ||
*[[Manuals/calci/REPLACE | REPLACE]] | *[[Manuals/calci/REPLACE | REPLACE]] | ||
*[[Manuals/calci/REPT | REPT]] | *[[Manuals/calci/REPT | REPT]] | ||
| Line 59: | Line 61: | ||
*[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 ]] | ||
Latest revision as of 16:49, 13 August 2018
SEARCH (Find_Text,Within_Text,Start_Num)
where
- is the text to search in original string,
- is the original string from which mentioned text is to be searched, and
- 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.
is the text to search in original string,
is the original string from which mentioned text is to be searched, and
is an optional argument that specifies the character position to start the search.
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).
- can be any string containing characters, numbers, symbols, blank spaces etc.
- and when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
- Argument is optional. If omitted, Calci assumes to be 1.
- should be an integer > 0, else Calci displays #NULL error message.
- If > 'length of text', Calci displays #N/A error message.
- If string specified in is not a part of the reference string , 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
See Also
References