The RFIND function searches a string for a sub-string of characters beginning with the right-most character in a string and based on the function’s context, returns the sub-string when found, the position of the first character of the sub-string within the source string, or an indictor of whether the sub-string was found. This search can optionally be case-insensitive and may begin at the right-most character of the source string, or somewhere within the source string by specifying the first position, counting from the left, to begin searching.
When RFIND is called in a string context, the function will search a source string for a sub-string, returning that sub-string when found, or an empty string if not found.
When RFIND is called in an integral number context, the function will search a source string for a sub-string, returning the position of the first character of the sub-string within the source string when found, or -1 if not found. The left-most character of the source string is at position 0.
When RFIND is called in a Boolean context, the function will search a source string for a sub-string, returning true when found, or false if not found.
| @RFIND (Source String, Search String [, Case Sensitive [, Start Position]]) | |
|---|---|
Source String | Required string parameter; contains the string value to be searched
by the function. |
Search String | Required string parameter; contains the string value to search
for within Source String. |
Case Sensitive | Optional Boolean parameter; when provided, specifies whether
or not the search of Source String for the Search
String value should be case-sensitive. When this value
is true or not provided, the search is case-sensitive. If this value
is false, case is ignored. |
Start Position | Optional integral number parameter; when provided, specifies
the zero-based character position, counting from the left, within Source
String to begin the search. If this value is not provided,
the search begins at the right-most character within Source
String. If this value is 0 or negative, an empty string
is returned. If this value is equal to or greater than the total
number of characters within Source String, the
entire string is searched. |