> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-transformation/formulas/string-functions/substringdelimiter.md).

# SubstringDelimiter

Returns substring starting and ending by the specified string delimiters

```mathematica
SubstringDelimiter("Tea with lemon and sugar", "Tea", "lemon") → "Tea with lemon"
SubstringDelimiter("200 USD 50 CENT", "200", "USD") → "200 USD"
```

#### Inputs

`SubstringDelimiter(string, startAfter, endBefore, [index])`

* `string` - A text value
* `startAfter` - Text delimiter to start the search after
* `endBefore` - Text delimiter to end the search before
* `[index]` - **\[optional**: `0` by default\*\*]\*\*