Share via

Split and Unpivot Comma-Separated Values

  • Article

This article was moved to DataChant.com. You can read it here.

Comments

  • Anonymous
    November 08, 2015
    What a nice journey - great storytelling - cannot remember a better reasoning to learn some M-code :-)

    Your splitter-function has a very powerful companion: Splitter.SplitTextByAnyDelimiter. The additional "Any" will enable you to split fields by many different delimiters.
    You type them in like in your example and simply separate them by commas. Finally wrapping them in curly brackets which transforms them into a list: Splitter.SplitTextByAnyDelimiter({",", ";", "-"})

    Candidate for the 2nd most coolest PQ-feature in my eyes :-)
  • Anonymous
    February 04, 2016
    Use this a lot at the library and this will help me a lot in my obituaries that I am doing