Manuals/calci/FIND

FIND (FindText,WithinText,StartNumber)

• $FindText$ is the text you want to find.
• $WithinText$ is the text or string that contains the text you want to find.
• $StartNumber$ is the number to start the search.
  • FIND(),finds one text value within another (case-sensitive).

Description

• FIND is used to locate the starting position of a search text in another string. ie, it will search the text inside another string and will return the starting position of the text inside the string.
• First character in $n$ is character number 1. By default $n$ is assumed to be 1 and is optional.
• FIND is used with languages that use the single-byte character set(SBCS).
• FINDB is used with languages that use the double-byte character set (DBCS).
• The default language of your computer will result in the return value

1. $FIND$ counts each character. It wont depend on default language setting.
2. Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle FINDB} counts double-byte character as 2.

• 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} 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 FINDB} are case sensitive. It won't allow wildcard characters.
• 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 FindText} is "" (NULL), FIND matches with the first character in the search string.

It will return ERROR when:

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 FindText}
 must not be wildcard characters.
2.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 FindText}
 is not there 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 WithinText}

3.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 StartNumber}
 is greater than the length of 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 WithinText}
.

Examples

	A
1	UNITED STATES OF AMERICA
2	30338
3	student
4	Personal

• =FIND("STATES",A1) = 8
• =FIND("dent",A3) = 4

Related Videos

FIND Function

See Also

• FINDB
• MID
• MIDDB

References

Find

• List of Main Z Functions

• Z3 home