Text.SplitAny Function in Power Query
The Text.SplitAny function returns a list of text values resulting from the splitting a text value text based on any character in the specified delimiter, separators.
Syntax
Text.SplitAny(text as text, separators as text) as list
Example:
Power Query M
let
Source = Text.SplitAny("Hi!, Ashish Goel is a developer.", " ")
in
Source The output of the above code is shown below:
