Updated on

Splitter.SplitTextByWhitespace is a Power Query M function that splits text into a list at whitespace. The function returns a list of text segments after applying the whitespace-based splitting.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Splitter.SplitTextByWhitespace( optional quoteStyle as nullable number ) as function


Returns a function that splits text into a list of text at whitespace.


Split the input by whitespace characters, treating quotes like any other character.

// Output: {"a", "b", "c"}
Splitter.SplitTextByWhitespace( QuoteStyle.None )( "a b#( tab )c" )

Used by

While the Splitter.SplitTextByWhitespace function can be used on its own, it is also used by the following functions:

Other functions related to Splitter.SplitTextByWhitespace are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/splitter-splittextbywhitespace