writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + Line 13:
Line 13: − + − + − + − +
no edit summary
<div style="font-size:30px">'''FIND (text,textstring,num)'''</div><br/>
<div style="font-size:30px">'''FIND (txt,txtst,n)'''</div><br/>
*<math>text</math> is the text you want to find.
*<math>txt</math> is the text you want to find.
*<math>textstring</math> is the text or string that contains the text you want to find.
*<math>txtst</math> is the text or string that contains the text you want to find.
*<math>num</math> is the number to start the search.
*<math>n</math> is the number to start the search.
==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>num</math> is character number 1. By default <math>num</math> is assumed to be 1 and is optional.
*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).
#<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>text</math> is "" (NULL), FIND matches with the first character in the search string.
*If <math>txt</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>text</math> must not be wildcard characters.
1.<math>txt</math> must not be wildcard characters.
2.If <math>text</math> is not there in <math>textstring</math>
2.If <math>txt</math> is not there in <math>textstring</math>
3.If <math>num</math> is greater than the length of <math>textstring</math>.
3.If <math>n</math> is greater than the length of <math>txtst</math>.
==Examples==
==Examples==