Category: Text function
This function returns the characters between the first occurrence of keep_start and the first occurrence of keep_end in text.
| Argument | Type | Description |
|---|---|---|
| text | Text | The text value to search within for the after_string string. |
| keep_start | Text (must not be empty) | The text string to search for within text defining the starting point of the string to be returned (not including this string). |
| keep_end | Text (must not be empty) | The text string to search for within text defining the end point of the string to be returned (not including this string). |
Return value type: Text
This function is case sensitive.
text, keep_start, and keep_end are implicitly converted to text values if required.
If keep_start is not found within text, all text from the start of text to keep_end.
If keep_end is not found within text, all text from the keep_start to the end of text is returned.
If neither keep_start nor keep_end are found within text, an (empty) value is returned.
keepbetween('http://easymorph.com', 'http://', '.com' ) //Returns 'easymorph'
keepbetween('192.168.0.1 "GET /download.html HTTP/1.1"', '/', ' ') //Returns download.html
keepbetween('Mary Joe Smith', 'Mary ', ' Smith') //Returns 'Joe'
keepbetween('Mary Joe Smith', 'Mark ', ' Smith') //Returns 'Mary Joe' ('Mark' not found)
keepbetween('Mary Joe Smith', 'Mary ', ' Jones') //Returns 'Joe Smith' ('Jones' not found)
keepbetween('Mary Joe Smith', 'Mark ', ' Jones') //Returns (empty) (Neither 'Mark' nor 'Jones' are found)