Forum Discussion
Solved
Split columns
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(d...
My mistake was I did not let the function to create a columns.
I added {"title", "1".."5"} and now that is ok.
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