Text.BeforeDelimiter
Syntax
Text.BeforeDelimiter(text as nullable text, delimiter as text, optional index as any) as any
About
Returns the portion of text
before 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" before the (first) hyphen.
Usage
Text.BeforeDelimiter("111-222-333", "-")
Output
"111"
Example 2
Get the portion of "111-222-333" before the second hyphen.
Usage
Text.BeforeDelimiter("111-222-333", "-", 1)
Output
"111-222"
Example 3
Get the portion of "111-222-333" before the second hyphen from the end.
Usage
Text.BeforeDelimiter("111-222-333", "-", {1, RelativePosition.FromEnd})
Output
"111"