Difference between revisions of "Documentation/How Tos/Calc: FIND function"

Revision as of 13:48, 25 February 2009

Returns the position of a string of text within another string.

FIND(findtext; texttosearch; startposition)

returns the character position of the first occurrence of findtext within texttosearch.

startposition (optional) is the position from which the search starts.

The search is case-sensitive.

A failed search gives the #VALUE! error.

FIND("yo"; "Yoyo")

returns 3.

FIND("cho"; "choochoo"; 2)

returns 5.

@@ Line 21: / Line 21: @@
 : returns <tt>'''5'''</tt>.
-=== See also: ===
+{{Documentation/SeeAlso|
-'''[[Documentation/How_Tos/Calc: REPLACE function|REPLACE]]''',
+* [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]]
-'''[[Documentation/How_Tos/Calc: SEARCH function|SEARCH]]''',
+* [[Documentation/How_Tos/Calc: SEARCH function|SEARCH]]
-'''[[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]]''',
+* [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]]
-'''[[Documentation/How_Tos/Calc: EXACT function|EXACT]]'''
+* [[Documentation/How_Tos/Calc: EXACT function|EXACT]]'''
-'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
+* [[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
-[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
-[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}