SubstringDelimiter
Returns substring starting and ending by the specified string delimiters
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 valuestartAfter
- Text delimiter to start the search afterendBefore
- Text delimiter to end the search before[index]
- [optional:0
by default**]**