2 Replies Latest reply on Feb 25, 2012 11:08 AM by BruceRobertson

    Expanding/Collapsing Consecutive Values

    BruceRobertson

      I know I've seen this somewhere. But I'm looking for a way to collapse/expand ranges of consecutive values such as numbers or dates.

       

      Let's take the a simple example. 1,2,3,4,5,7,8,10,12,13,14 = 1..5,7..8,10,12..14

       

      The end purpose of this is to provide a notation for arbitrary date ranges that include mixes of consecutive and non-consecutive dates.