Text.AfterDelimiter
Text.AfterDelimiter
function (optionaltextas nullable any,delimiteras text, optionalindexas nullable any) as nullable any
Returns the portion of
text after the specified delimiter. An optional numeric index indicates which occurrence of the delimiter should be considered. An optional list index indicates which occurrence of the delimiter should be considered, as well as whether indexing should be done from the start or end of the input.Text.Transformations
Get the portion of "111-222-333" after the (first) hyphen.
Text.AfterDelimiter("111-222-333", "-")
"222-333"
Get the portion of "111-222-333" after the second hyphen.
Text.AfterDelimiter("111-222-333", "-", 1)
"333"
Get the portion of "111-222-333" after the second hyphen from the end.
Text.AfterDelimiter("111-222-333", "-", {1, RelativePosition.FromEnd})
"222-333"
Last modified 4yr ago