This function finds a string pattern find$ within another string within$ starting from the specified position StartPos, and returns an integer corresponding to the ending position of find$ in within$. This function allows the wildcard characters "*" and "?".
int MatchEnd(within$, find$ [, StartPos, Case])
NOTE: Order of string arguments is reverse of MS Excel's Search and Find functions.
- is the containing string.
- is the string pattern you want to find.
- [optional] integer that specifies the position of the character at which to start the search. The default value is 1, which means to find from the first character.
- [optional] integer that specifies whether the function is case sensitive or not. The default value is 0 or false, which means the function is not case sensitive unless n is set to 1.
If the string pattern has been found, return the ending position of the string pattern.
If the string pattern has not been found, return -1.
Note 1: When using wildcards ? and *, MatchEnd returns the index for the first non-wildcard character (see second Example, below).
Note 2: MatchEnd does not support searches for raw characters ? or *. To search a string for ? or *, use the Search function (which does not support wildcards).
string str1$ = "From: test@Originlab.com";
string str2$ = "From*@";
int position = MatchEnd(str1$,str2$,1);
position = ; //should return 11
int position = MatchEnd("search inside this string","in?");
position=; //should return 9