Combiner.CombineTextByDelimiter
Syntax
Combiner.CombineTextByDelimiter(delimiter as text, optional quoteStyle as nullable number) as function
About
Returns a function that combines a list of text values into a single text value using the specified delimiter.
Example 1
Combine a list of text values using a semicolon delimiter.
Usage
Combiner.CombineTextByDelimiter(";")({"a", "b", "c"})
Output
"a;b;c"
Example 2
Combine the text of two columns using a comma delimiter and CSV-style quoting.
Usage
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
#table(
type table [Merged = text],
{{"a,b"}, {"c,""d,e,f"""}}
)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for