Text.Split

Syntax

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

About

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

Example 1

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

Usage

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

Output

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