How to: Extract a part of a delimited string.

Goal

Given a sting with text separated by a delimiter character, extract one specific element within the string.

Learn

If the source string is separated by a delimiter, e.g. _ (underscore), a LIST object can be created, using the delimiter character as a list elements separator.

• Use the LISTELEMENT function to get the desired part of the string.

Example

• Given an initial string of Text1_Text2_Text3 some text _Text4.
• Using TOKENIZELIST with _ (underscore) as a separator would return the following list from this string: [Text1, Text2, Text3 some text , Text4]. Formula: TOKENIZELIST(#InitialString;"_")
• How to get specific element "N" from the list.
  Formula LISTELEMENT(TOKENIZELIST(#InitialString;"_");N-1).
  Note: An elements count for LISTELEMENT starts from 0.