Combiner.CombineTextByDelimiter
This function returns a result of combining multiple text values in a list, using a designated separator.
Combiner.CombineTextByDelimiter(delimiter as text, optional quoteStyle as nullable number) as functionThis function returns a result of combining multiple text values in a list, using a designated separator.
Example 1
Utilize Power Query MCombiner function to concatenate a list of text values by using a semicolon as the delimiter.
Usage:
Power Query MCombiner.CombineTextByDelimiter(";")({"a", "b", "c"})
Output:
"a;b;c"
Example 2
Merge the text from two columns by using a comma as the delimiter and CSV-style quoting.
Usage:
Power Query M
let
Source = #table(
type table [Column1 = text, Column2 = text],
{{"a", "b"}, {"c", "d,e,f"}}
),
Merged = Table.CombineColumns(
Source,
{"Column1", "Column2"},
Combiner.CombineTextByDelimiter(",", QuoteStyle.Csv),
"Merged"
)
in
Merged
Output:
Power Query M
#table(
type table [Merged = text],
{{"a,b"}, {"c,""d,e,f"""}}
)