Text.Split

Syntax

Text.Split(text as text, separator as text) as list

About

Returns a list of text values resulting from the splitting of a text value based on the specified delimiter.

  • text: The text value to split.
  • separator: The delimiter used to split the text. The delimiter can be either a single character or a sequence of characters. If a sequence of characters is used, the text is split only at instances where the exact sequence occurs.

Example 1

Create a list from the "|" delimited text value "Name|Address|PhoneNumber".

Usage

Text.Split("Name|Address|PhoneNumber", "|")

Output

{
    "Name",
    "Address",
    "PhoneNumber"
}

Example 2

Create a list from the text value using a sequence of characters.

Usage

Text.Split("Name, the Customer, the Purchase Date", ", the ")

Output

{
    Name,
    Customer,
    Purchase Date
}