Text.Split
Splits text into a list of text values based upon a specified delimiter.
function (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
.Text.Transformations
Create a list from the "|" delimited text value "Name|Address|PhoneNumber".
Text.Split("Name|Address|PhoneNumber", "|")
{ "Name", "Address", "PhoneNumber" }
Last modified 4yr ago