Text.AfterDelimiter
function (optional
text
as nullable any,delimiter
as text, optionalindex
as 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"