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:
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
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy