Split and Unpivot Comma-Separated Values

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