Table of Contents

KeepBetween(text, keep_start, keep_end)

Category: Text function


Description

This function returns the characters between the first occurrence of keep_start and the first occurrence of keep_end in text.


Arguments

ArgumentTypeDescription
textTextThe text value to search within for the after_string string.
keep_startText (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_endText (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


Remarks

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.


Examples

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)


See also