StringPart

The StringPart() function splits a text into an array of text values, and returns the part at a specified position.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the part of a text that can be determined by splitting it on the indicated separator and then taking the resulting part at the indicated position. Returns Invalid expression if one of the parameters is not valid.

Syntax

StringPart(text, separator, position)

StringPart("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",", 3) => "Mar"

Parameters

Name	Type	Required	Description
text	text	☑️	The text to split
separator	text	☑️	Specifies the character(s) to use for separating the text
position	text	☑️	The position of the part to return