Splitter functions

Splitter functions functions for Power Query M language.

Functions

FunctionDescription
Splitter.SplitByNothingReturns a function that does not divide, but instead returns its argument as a list containing a single element.
Splitter.SplitTextByAnyDelimiterThis function returns a result of splitting a given piece of text into a list of smaller text chunks, based on user-specified delimiters.
Splitter.SplitTextByCharacterTransitionThis function produces a result that separates text into a list based on a change from one type of character to another. The before and after inputs can be a list of characters, or a function that eva...
Splitter.SplitTextByDelimiterThe function returns a result by dividing the input text into separate parts based on the chosen separator.
Splitter.SplitTextByEachDelimiterThis function will return a new function that will separate a given text into a list of smaller texts, with each text being split at a specified delimiter in the order they appear.
Splitter.SplitTextByLengthsThis function returns a result where the input text is divided into smaller text segments based on a specified length, and the segments are stored in a list.
Splitter.SplitTextByPositionsThis function returns a new function that divides a string into a list of strings based on specified positions.
Splitter.SplitTextByRangesThis function returns a result that divides a given text into smaller sections based on specified starting points and lengths. If a length is set to zero, the remainder of the input will be included i...
Splitter.SplitTextByRepeatedLengthsThis function will return a new function that breaks down a piece of text into smaller segments, each segment being the specified length, and then arranges these segments into a list.
Splitter.SplitTextByWhitespaceThis function will return a result that breaks down the input text into separate elements based on the presence of white spaces.