Power Query
published
Search
⌃K

Text.AfterDelimiter

Text.AfterDelimiter

Text.AfterDelimiter
function (optional text as nullable any, delimiter as text, optional index as nullable any) as nullable any

Description

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.

Category

Text.Transformations

Examples

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"