Splitter.SplitTextByWhitespace

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

Syntax

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

Description

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

Examples

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 you can use the Splitter.SplitTextByWhitespace function by itself, it also works together with:

• Table.FromList
• Table.SplitColumn

Related functions

Other functions related to Splitter.SplitTextByWhitespace are:

• Splitter.SplitByNothing
• Splitter.SplitTextByAnyDelimiter
• Splitter.SplitTextByCharacterTransition
• Splitter.SplitTextByDelimiter
• Splitter.SplitTextByEachDelimiter
• Splitter.SplitTextByLengths
• Splitter.SplitTextByPositions
• Splitter.SplitTextByRanges
• Splitter.SplitTextByRepeatedLengths

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