Splitter functions

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

FunctionDescription
Splitter.SplitByNothingReturns a function that does no splitting, returning its argument as a single element list.
Splitter.SplitTextByAnyDelimiterReturns a function that splits text by any supported delimiter.
Splitter.SplitTextByDelimiterReturns a function that will split text according to a delimiter.
Splitter.SplitTextByEachDelimiterReturns a function that splits text by each delimiter in turn.
Splitter.SplitTextByLengthsReturns a function that splits text according to the specified lengths.
Splitter.SplitTextByPositionsReturns a function that splits text according to the specified positions.
Splitter.SplitTextByRangesReturns a function that splits text according to the specified ranges.
Splitter.SplitTextByRepeatedLengthsReturns a function that splits text into a list of text after the specified length repeatedly.
Splitter.SplitTextByWhitespaceReturns a function that splits text according to whitespace.
Parameter valuesDescription
QuoteStyle.CsvQuote characters indicate the start of a quoted string. Nested quotes are indicated by two quote characters.
QuoteStyle.NoneQuote characters have no significance.
Show: