Forum Discussion

Ara_Karapetyan's avatar
Ara_Karapetyan
Helper I
2 years ago
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...
Need Help
  • Ara_Karapetyan's avatar
    Ara_Karapetyan
    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.

ronrsnfld's avatar
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?