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

Syntax

StringPart(text, separator, position)

Returns

The part at a position in an array of text values split at each point where the separator occurs in the given text

Parameters

  • text – The text to split
  • separator – Specifies the character(s) to use for separating the text
  • position – The position of the part to return

Examples

Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",", 3)
/* Returns "Mar" */

Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",", 0)
/* Returns unknown text */

Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",", 15)
/* Returns unknown text */

Split("The quick brown fox jumps over the lazy dog.", " ", 1)
/* Returns "The" */

Split("The Answer to the Ultimate Question of Life, The Universe, and Everything.", "The", 2)
/* Returns " Universe, and Everything." */

 +31 (0)20 240 21 20       

Videos and images courtesy of WEM Modeler. © 2019. WEM Modeler.
SitemapPrivacy - Terms - Company

 +31 (0)20 240 21 20       


Videos and images courtesy of WEM Modeler.
© 2019 WEM Modeler.
SitemapPrivacy - Terms - Company