Splitter.SplitTextByDelimiter

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

Argument	Attribute	Description
delimiter		The delimiter used to split a text value.
quoteStyle	optional	You 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 you can use the Splitter.SplitTextByDelimiter function by itself, it also works together with:

• Table.FromList
• Table.SplitColumn

Related functions

Other functions related to Splitter.SplitTextByDelimiter are:

• Splitter.SplitByNothing
• Splitter.SplitTextByAnyDelimiter
• Splitter.SplitTextByCharacterTransition
• Splitter.SplitTextByEachDelimiter
• Splitter.SplitTextByLengths
• Splitter.SplitTextByPositions
• Splitter.SplitTextByRanges
• Splitter.SplitTextByRepeatedLengths
• Splitter.SplitTextByWhitespace

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