Skip to main content

Text.BeforeDelimiter

Text.BeforeDelimiter

Syntax

Text.BeforeDelimiter(
text as text,
delimiter as text,
optional index as any
) as any

Remarks

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.

Examples

Example #1

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

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

Result:

"111"

Example #2

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

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

Result:

"111-222"

Example #3

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

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

Result:

"111"

Category

Text.Transformations