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 …