Difference between revisions of "Manuals/calci/SEARCH"
Jump to navigation
Jump to search
| 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. | ||
Revision as of 16:48, 13 August 2018
SEARCH (Find_Text,Within_Text,Start_Num)
where
- Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle Find_{T}ext} is the text to search in original string,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Within_Text} is the original string from which mentioned text is to be searched, and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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).
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Within-Text} can be any string containing characters, numbers, symbols, blank spaces etc.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Find-Text} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Within_Text} when directly entered in the command, should be enclosed in double quotes (e.g. "Name").
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Start-Num} is optional. If omitted, Calci assumes to be 1.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Start-Num} should be an integer > 0, else Calci displays #NULL error message.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Start-Num} > 'length of text', Calci displays #N/A error message.
- If string specified in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Find-Text} is not a part of the reference string Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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
See Also
References