SplitPart

Description

SplitPart splits text by a delimiter and returns the specified part.

Syntax

SplitPart(text, delimiter, index)

Parameters

Parameter	Required	Type	Description
text	Yes	String, field, or expression	Source text.
delimiter	Yes	String	Delimiter used to split text.
index	Yes	Integer	Part index to return.

Notes

Use this function in calculated fields, metric expressions, or query expressions where the function category is supported.

Example

SplitPart(CategoryPath, "/", 2)

The expression returns the calculated result according to the current query context.