TextBetween() returns the text in the parent string that occurs between the characters specified as delimiters. The text string between the first occurrence of the delimiters is returned unless an optional third argument (with a value greater than 1) is supplied.
Syntax:
TextBetween(text, delimiter1, delimiter2[, n])
Return data type: string
Arguments:
| Argument | Description |
|---|---|
| text | The original string. |
| delimiter1 | Specifies the first delimiting character (or string) to search for in text. |
| delimiter2 | Specifies the second delimiting character (or string) to search for in text. |
| count | Defines which occurrence of the delimiter pair to search between. For example, a value of 2 returns the characters between the second occurrence of the delimiter pair. |