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

    Create inclusive number lists

    LeahGrrl

      Title

      Create inclusive number lists

      Post

      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

       

      Impossible?

       

      Thanks so much for any help.

       

      LeahGrrl