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	Input	Output
Splitter.SplitByNothing	Returns a function that does no splitting, returning its argument as a single element list.	Function	Function
Splitter.SplitTextByAnyDelimiter	Returns a function that splits text into a list of text at any of the specified delimiters.	List	Function
Splitter.SplitTextByCharacterTransition	Returns a function that splits text into a list of text according to a transition from one kind of character to another	Any	Function
Splitter.SplitTextByDelimiter	Returns a function that splits text into a list of text according to the specified delimiter.	Text	Function
Splitter.SplitTextByEachDelimiter	Returns a function that splits text into a list of text at each specified delimiter in sequence.	List	Function
Splitter.SplitTextByLengths	Returns a function that splits text into a list of text by each specified length.	List	Function
Splitter.SplitTextByPositions	Returns a function that splits text into a list of text at each specified position.	List	Function
Splitter.SplitTextByRanges	Returns a function that splits text into a list of text according to the specified offsets and lengths.	List	Function
Splitter.SplitTextByRepeatedLengths	Returns a function that splits text into a list of text after the specified length repeatedly.	Number	Function
Splitter.SplitTextByWhitespace	Returns a function that splits text into a list of text at whitespace.	Number	Function

Last update: November 24, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/splitter-functions
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.