Splitter.SplitTextByWhitespace

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

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:

Other functions related to Splitter.SplitTextByWhitespace are:

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

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy