Text.SplitAny

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Returns a list containing parts of a text value that are delimited by any separator text values.

Text.SplitAny(string as text,  separator as text) as list  

ArgumentDescription
stringThe string to parse.
separatorA delimiter value.
Show: