Splitter Functions
Splitter.SplitTextByDelimiter
Syntax Splitter.SplitTextByDelimiter(delimiter as text, optional quoteStyle as nullable number) as function Description Returns a function …
QuoteStyle.Csv
Syntax null Description Quote characters indicate the start of a quoted string. Nested quotes are …
QuoteStyle.None
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.SplitTextByCharacterTransition
Syntax Splitter.SplitTextByCharacterTransition(before as anynonnull, after as anynonnull) as function Description Returns a function that splits …
Splitter.SplitByNothing
Syntax Splitter.SplitByNothing() as function Description Returns a function that does no splitting, returning its argument …
Splitter.SplitTextByRanges
Syntax Splitter.SplitTextByRanges(ranges as list, optional startAtEnd as nullable logical) as function Description Returns a function …
Splitter.SplitTextByPositions
Syntax Splitter.SplitTextByPositions(positions as list, optional startAtEnd as nullable logical) as function Description Returns a function …
Splitter.SplitTextByRepeatedLengths
Syntax Splitter.SplitTextByRepeatedLengths(length as number, optional startAtEnd as nullable logical) as function Description Returns a function …
Splitter.SplitTextByEachDelimiter
Syntax Splitter.SplitTextByEachDelimiter(delimiters as list, optional quoteStyle as nullable number, optional startAtEnd as nullable logical) as …
Splitter.SplitTextByWhitespace
Syntax Splitter.SplitTextByWhitespace(optional quoteStyle as nullable number) as function Description Returns a function that splits text …
Splitter.SplitTextByAnyDelimiter
Syntax Splitter.SplitTextByAnyDelimiter(delimiters as list, optional quoteStyle as nullable number, optional startAtEnd as nullable logical) as …
Splitter.SplitTextByLengths
Syntax Splitter.SplitTextByLengths(lengths as list, optional startAtEnd as nullable logical) as function Description Returns a function …