BruceRobertson

Expanding/Collapsing Consecutive Values

Discussion created by BruceRobertson on Feb 24, 2012
Latest reply on Feb 25, 2012 by 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.

Outcomes