Power Query
Search…
Text.SplitAny

Text.SplitAny

Returns a list of text values, split on any of the characters in the delimiter.
function (text as text, separators as text) as list

Description

Returns a list of text values resulting from the splitting a text value text based on any character in the specified delimiter, separators.

Category

Text.Transformations

Examples

Create a list from the text value "Jamie|Campbell|Admin|Adventure Works|www.adventure-works.com".
1
Text.SplitAny("Jamie|Campbell|Admin|Adventure Works|www.adventure-works.com", "|")
Copied!
{"Jamie", "Campbell", "Admin", "Adventure Works", "www.adventure-works.com"}
Last modified 3yr ago