← Back to Text functions

Text.SplitAny

This function generates a list of text values by dividing a given text value based on any character present in the specified delimiter set.

Syntax

Text.SplitAny(text as text, separators as text) as list

About

This function generates a list of text values by dividing a given text value based on any character present in the specified delimiter set.

Explanation

Generate a list by splitting the text value "Jamie|Campbell|Admin|Adventure Works|www.adventure-works.com" using the Power Query function MText.SplitAny. The output will be: { "Jamie", "Campbell", "Admin", "Adventure Works", "www.adventure-works.com" }