Splitter functions
Splitter functions functions for Power Query M language.
Functions
Function | Description |
---|---|
Splitter.SplitByNothing | Returns a function that does not divide, but instead returns its argument as a list containing a single element. |
Splitter.SplitTextByAnyDelimiter | This function returns a result of splitting a given piece of text into a list of smaller text chunks, based on user-specified delimiters. |
Splitter.SplitTextByCharacterTransition | This 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.SplitTextByDelimiter | The function returns a result by dividing the input text into separate parts based on the chosen separator. |
Splitter.SplitTextByEachDelimiter | This 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.SplitTextByLengths | This 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.SplitTextByPositions | This function returns a new function that divides a string into a list of strings based on specified positions. |
Splitter.SplitTextByRanges | This 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.SplitTextByRepeatedLengths | This 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.SplitTextByWhitespace | This function will return a result that breaks down the input text into separate elements based on the presence of white spaces. |