Splitter.SplitTextByDelimiter

Updated on

Splitter.SplitTextByDelimiter is a Power Query M function that splits text into a list using the specified delimiter. The function returns a list of text segments after applying the delimiter-based splitting.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Splitter.SplitTextByDelimiter(
   delimiter as text,
   optional quoteStyle as nullable number,
) as function
ArgumentAttributeDescription
delimiterThe delimiter used to split a text value.
quoteStyleoptionalYou can provide a QuoteStyle Type that instructs how to deal with double quote characters. You can choose from QuoteStyle.None or QuoteStyle.Csv.

Description

Returns a function that splits text into a list of text according to the specified delimiter.

Examples

Split the input by comma, ignoring quoted commas.

// Output: {"a", "b,c", "d"}
Splitter.SplitTextByDelimiter( ",", QuoteStyle.Csv )( "a,""b,c"",d" )

Used by

While the Splitter.SplitTextByDelimiter function can be used on its own, it is also used by the following functions:

Other functions related to Splitter.SplitTextByDelimiter are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/splitter-splittextbydelimiter