Syntax Splitter.SplitTextByAnyDelimiter(delimiters as list, optional quoteStyle as nullable number, optional startAtEnd as nullable logical) as function Description Returns a function that splits text into a list of text at any of the specified delimiters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions /… Read More »Splitter.SplitTextByAnyDelimiter
Syntax Splitter.SplitTextByWhitespace(optional quoteStyle as nullable number) as function Description Returns a function that splits text into a list of text at whitespace. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / Splitter.SplitTextByWhitespace
Syntax Splitter.SplitTextByEachDelimiter(delimiters as list, optional quoteStyle as nullable number, optional startAtEnd as nullable logical) as function Description Returns a function that splits text into a list of text at each specified delimiter in sequence. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions /… Read More »Splitter.SplitTextByEachDelimiter
Syntax Splitter.SplitTextByRepeatedLengths(length as number, optional startAtEnd as nullable logical) as function Description Returns a function that splits text into a list of text after the specified length repeatedly. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / Splitter.SplitTextByRepeatedLengths
Syntax Splitter.SplitTextByPositions(positions as list, optional startAtEnd as nullable logical) as function Description Returns a function that splits text into a list of text at each specified position. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / Splitter.SplitTextByPositions
Syntax Splitter.SplitTextByRanges(ranges as list, optional startAtEnd as nullable logical) as function Description Returns a function that splits text into a list of text according to the specified offsets and lengths. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / Splitter.SplitTextByRanges
Syntax Splitter.SplitByNothing() as function Description Returns a function that does no splitting, returning its argument as a single element list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / Splitter.SplitByNothing
Syntax Splitter.SplitTextByCharacterTransition(before as anynonnull, after as anynonnull) as function Description Returns a function that splits text into a list of text according to a transition from one kind of character to another. The before and after parameters can either be a list of characters, or… Read More »Splitter.SplitTextByCharacterTransition
Syntax null Description Quote characters have no significance. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / QuoteStyle.None
Syntax null Description Quote characters indicate the start of a quoted string. Nested quotes are indicated by two quote characters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / QuoteStyle.Csv