← Back to Splitter functions

Splitter.SplitTextByWhitespace

This function will return a result that breaks down the input text into separate elements based on the presence of white spaces.

Syntax

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

About

This function will return a result that breaks down the input text into separate elements based on the presence of white spaces.

Explanation

Divide the input based on spaces, considering quotes as regular characters. Usage: Power Query MSplitter.SplitTextByWhitespace(QuoteStyle.None)("a b#(tab)c") Result: {"a", "b", "c"}