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.

WEM functions are 1-based where it concerns position parameters: 1 is the first position.

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 (1-based)

Last updated

Was this helpful?