AnsweredAssumed Answered

Create inclusive number lists

Question asked by LeahGrrl on Sep 3, 2009
Latest reply on Sep 3, 2009 by LeahGrrl


Create inclusive number lists


Hi there,


Thanks for your patience. Here's what I am trying to do: I created a calculation that will take a join table of items and page numbers; e.g.,

[termx] 32

[termx] 33

[termx] 34...etc.


and turned it into

[termx]  32, 33, 34, 35, 36, 39, 40, 41, 55, 58

so there's a new text field using List() and Substitute()  to make that nice row of page numbers.


Now, of course, what I'd like to do is display it more like an index:

[term] 32-36, 39-41, 55, 58




Thanks so much for any help.