Splitter.SplitTextByWhitespace

Syntax

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

About

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

Example 1

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

Usage

Power Query M

Splitter.SplitTextByWhitespace(QuoteStyle.None)("a b#(tab)c")

Output

{"a", "b", "c"}