Splitter Functions Overview

Updated on

Learn about Splitter Functions in Power Query M Language, vital for splitting data into parts. This page provides a comprehensive list and descriptions of Splitter Functions available in the M Language.

Splitter Functions

FunctionDescriptionInputOutput
Splitter.SplitByNothingReturns a function that does no splitting, returning its argument as a single element list.FunctionFunction
Splitter.SplitTextByAnyDelimiterReturns a function that splits text into a list of text at any of the specified delimiters.ListFunction
Splitter.SplitTextByCharacterTransitionReturns a function that splits text into a list of text according to a transition from one kind of character to anotherAnyFunction
Splitter.SplitTextByDelimiterReturns a function that splits text into a list of text according to the specified delimiter.TextFunction
Splitter.SplitTextByEachDelimiterReturns a function that splits text into a list of text at each specified delimiter in sequence.ListFunction
Splitter.SplitTextByLengthsReturns a function that splits text into a list of text by each specified length.ListFunction
Splitter.SplitTextByPositionsReturns a function that splits text into a list of text at each specified position.ListFunction
Splitter.SplitTextByRangesReturns a function that splits text into a list of text according to the specified offsets and lengths.ListFunction
Splitter.SplitTextByRepeatedLengthsReturns a function that splits text into a list of text after the specified length repeatedly.NumberFunction
Splitter.SplitTextByWhitespaceReturns a function that splits text into a list of text at whitespace.NumberFunction
BI Gorilla Blog

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