Table of contents
TOC
Collapse the table of content
Expand the table of content

Text.AfterDelimiter

Owen Duncan|Last Updated: 4/19/2018
|
1 Contributor

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

About

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.

Example 1

Get the portion of "111-222-333" after the (first) hyphen.

Text.AfterDelimiter("111-222-333", "-")

"222-333"

Example 2

Get the portion of "111-222-333" after the second hyphen.

Text.AfterDelimiter("111-222-333", "-", 1)

"333"

Example 3

Get the portion of "111-222-333" after the second hyphen from the end.

Text.AfterDelimiter("111-222-333", "-", {1, RelativePosition.FromEnd})

"222-333"

© 2018 Microsoft