Text.SplitAny
A text cut into a list of pieces wherever any of the given characters appears.
Group: Text and characters. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Text.SplitAny(text as text, separators as text) as list| Parameter | Type | Description |
|---|---|---|
text | text | The text to cut. |
separators | text | Each character of this text is a separator on its own. |
Returns
list. The pieces, without the separators.
Examples
Semicolons and commas
Text.SplitAny("Oslo;Bergen,Trondheim", ";,"){"Oslo", "Bergen", "Trondheim"}