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**]**