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. $FINDB$ counts double-byte character as 2.

• $FIND$ and $FINDB$ are case sensitive. It won't allow wildcard characters.
• If $FindText$ is "" (NULL), FIND matches with the first character in the search string.

It will return ERROR when:

1.$FindText$ must not be wildcard characters.
2.If $FindText$ is not there in $WithinText$
3.If $StartNumber$ is greater than the length of $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