Splitter Functions Overview

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

Function	Description
Splitter.SplitByNothing	Returns a function that does no splitting, returning its argument as a single element list.
Splitter.SplitTextByAnyDelimiter	Returns a function that splits text into a list of text at any of the specified delimiters.
Splitter.SplitTextByCharacterTransition	Returns a function that splits text into a list of text according to a transition from one kind of character to another
Splitter.SplitTextByDelimiter	Returns a function that splits text into a list of text according to the specified delimiter.
Splitter.SplitTextByEachDelimiter	Returns a function that splits text into a list of text at each specified delimiter in sequence.
Splitter.SplitTextByLengths	Returns a function that splits text into a list of text by each specified length.
Splitter.SplitTextByPositions	Returns a function that splits text into a list of text at each specified position.
Splitter.SplitTextByRanges	Returns a function that splits text into a list of text according to the specified offsets and lengths.
Splitter.SplitTextByRepeatedLengths	Returns a function that splits text into a list of text after the specified length repeatedly.
Splitter.SplitTextByWhitespace	Returns a function that splits text into a list of text at whitespace.

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