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 value

• startAfter - Text delimiter to start the search after

• endBefore - Text delimiter to end the search before

• [index] - [optional: 0 by default**]**