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. |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!