TextBetween() returns the text in the input string that occurs between the characters specified as delimiters.
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. |
| n | Defines which occurrence of the delimiter pair to search between. For example, a value of 2 returns the characters between the second occurrence of delimiter1 and the second occurrence of delimiter2. |
Examples and results:
| Example | Result |
|---|---|
| TextBetween('<abc>', '<', '>') | Returns 'abc' |
| TextBetween('<abc><de>', '<', '>',2) | Returns 'de' |
