Hi,I need to split columns by series of delimiters.I use a delimiters list: delimiters = {",", "-","—"}.The step I use is: Table.SplitColumn(source, "title", Splitter.SplitTextByEachDelimiter(delimiters, QuoteStyle.None)).Power Query splits with just the first delimiter from my list and ignores the rest ones. Thanks in advance.

My mistake was I did not let the function to create a columns.I added {"title", "1".."5"} and now that is ok.

Split columns | Microsoft Fabric Community

ronrsnfld
Super User
2 years ago
Hard to know what you are doing wrong without data that demonstrates the problem.

Please provide a data sample (as text which can be copy/pasted) that demonstrates the problem.

Perhaps you mean to use Splitter.SplitTextByAnyDelimiter?
Anonymous
Not applicable
2 years ago
Change your function to Text.SplitAny([TextColumn], ",", "-", "~"). I used the ~ because I don't have the long dash on my phone.

Text.SplitAny(text as text, separators as text) as list

--Nate
Anonymous
Not applicable
2 years ago
In fact, you can also use Splitter.SplitTextByAnyDelimiter or

Splitter.SplitTextByEachDelimiter

--Nate
Ara_Karapetyan
Helper I
2 years ago
My mistake was I did not let the function to create a columns.
I added {"title", "1".."5"} and now that is ok.