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.
| Function | Description |
|---|---|
| Splitter.SplitByNothing | Returns a function that does no splitting, returning its argument as a single element list. |
| Splitter.SplitTextByAnyDelimiter | Returns a function that splits text by any supported delimiter. |
| Splitter.SplitTextByDelimiter | Returns a function that will split text according to a delimiter. |
| Splitter.SplitTextByEachDelimiter | Returns a function that splits text by each delimiter in turn. |
| Splitter.SplitTextByLengths | Returns a function that splits text according to the specified lengths. |
| Splitter.SplitTextByPositions | Returns a function that splits text according to the specified positions. |
| Splitter.SplitTextByRanges | Returns a function that splits text according to the specified ranges. |
| Splitter.SplitTextByRepeatedLengths | Returns a function that splits text into a list of text after the specified length repeatedly. |
| Splitter.SplitTextByWhitespace | Returns a function that splits text according to whitespace. |
| Parameter values | Description |
|---|---|
| QuoteStyle.Csv | Quote characters indicate the start of a quoted string. Nested quotes are indicated by two quote characters. |
| QuoteStyle.None | Quote characters have no significance. |
Show: