Text.Split

Splits text into a list of text values based upon a specified delimiter.

Syntax

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

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

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

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

Result:

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