3 Replies Latest reply on Sep 3, 2009 10:14 AM by LeahGrrl

    Create inclusive number lists



      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.