Splitter.SplitTextByEachDelimiter
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns a function that splits text by each delimiter in turn.
Splitter.SplitTextByEachDelimiter(delimiters as list, optional quoteStyle as nullable number) as function
| Argument | Description |
|---|---|
| Delimiters | The delimiter characters are used to identify at what points to split the string. The delimiter character is not included in the split values. A trailing delimiter character will yield an additional empty text value. The split values contain all characters between the delimiters. This function will always produce at least one value. |
| optional quoteStyle | The quoteStyle acts as described in Lines.FromText. By default, it is QuoteStyle.Csv. |
- Splitter.SplitTextByEachDelimiter is similar to Splitter.SplitTextByDelimiter except that each delimiter is used once in order to determine the points at which to break the text.
Show: