Difference between revisions of "Manuals/calci/FIND"
Jump to navigation
Jump to search
| (11 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''FIND ( | + | <div style="font-size:30px">'''FIND (FindText,WithinText,StartNumber) '''</div><br/> |
| − | *<math> | + | |
| − | *<math> | + | *<math>FindText</math> is the text you want to find. |
| − | *<math> | + | *<math>WithinText</math> is the text or string that contains the text you want to find. |
| + | *<math>StartNumber</math> is the number to start the search. | ||
| + | **FIND(),finds one text value within another (case-sensitive). | ||
==Description== | ==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. | *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 <math> | + | *First character in <math>n</math> is character number 1. By default <math>n</math> is assumed to be 1 and is optional. |
*FIND is used with languages that use the single-byte character set(SBCS). | *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). | *FINDB is used with languages that use the double-byte character set (DBCS). | ||
| Line 13: | Line 15: | ||
#<math>FINDB</math> counts double-byte character as 2. | #<math>FINDB</math> counts double-byte character as 2. | ||
*<math>FIND</math> and <math>FINDB</math> are case sensitive. It won't allow wildcard characters. | *<math>FIND</math> and <math>FINDB</math> are case sensitive. It won't allow wildcard characters. | ||
| − | *If <math> | + | *If <math>FindText</math> is "" (NULL), FIND matches with the first character in the search string. |
It will return ERROR when: | It will return ERROR when: | ||
| − | 1.<math> | + | 1.<math>FindText</math> must not be wildcard characters. |
| − | 2.If <math> | + | 2.If <math>FindText</math> is not there in <math>WithinText</math> |
| − | 3.If <math> | + | 3.If <math>StartNumber</math> is greater than the length of <math>WithinText</math>. |
==Examples== | ==Examples== | ||
| + | <div id="6SpaceContent" class="zcontent" align="left"> | ||
| + | |||
| + | {| id="TABLE3" class="SpreadSheet blue" | ||
| + | |- class="even" | ||
| + | | | ||
| + | ! A | ||
| + | |- | ||
| + | |- class="odd" | ||
| + | |1 | ||
| + | |UNITED STATES OF AMERICA | ||
| + | |- class="even" | ||
| + | |2 | ||
| + | |30338 | ||
| + | |- class="odd" | ||
| + | |3 | ||
| + | |student | ||
| + | |- class="even" | ||
| + | |4 | ||
| + | |Personal | ||
| + | |} | ||
| + | *=FIND("STATES",A1) = 8 | ||
| + | *=FIND("dent",A3) = 4 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|43L6SNVoGdM|280|center|FIND Function}} | ||
==See Also== | ==See Also== | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/FINDB | FINDB ]] |
| + | *[[Manuals/calci/MID | MID ]] | ||
| + | *[[Manuals/calci/MIDB | MIDDB ]] | ||
==References== | ==References== | ||
| − | [http:// | + | [http://www.techonthenet.com/excel/formulas/find.php Find] |
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16:37, 9 August 2018
FIND (FindText,WithinText,StartNumber)
- is the text you want to find.
- is the text or string that contains the text you want to find.
- is the number to start the search.
- FIND(),finds one text value within another (case-sensitive).
is the text you want to find.
is the text or string that contains the text you want to find.
is the number to start the search.
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 is character number 1. By default 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
is character number 1. By default - counts each character. It wont depend on default language setting.
- counts double-byte character as 2.
counts each character. It wont depend on default language setting.
counts double-byte character as 2.- and are case sensitive. It won't allow wildcard characters.
- If is "" (NULL), FIND matches with the first character in the search string.
It will return ERROR when:
1. must not be wildcard characters. 2.If is not there in 3.If is greater than the length of .