4 Replies Latest reply on Aug 3, 2017 2:35 PM by philmodjunk

    filtervalues location

    gethappy@happypc.com

      I'm trying to get the NEXT (or PREVIOUS) value in a return separated list of values.

       

      So I have a global text field displaying a list of key values like

      43

      45

      46

      47

       

      and in a separate global field I have one of these values (i.e. '45').  I want to find a way to the next value ('46')

       

      I could use position to find the position of the 1st value ('45') and then the next "¶" ... but I have to think there's a better way since sometimes there wont be a paragraph (If the last value) and other complexities.

       

      In a perfect world, I could find that '45' is the 2nd value and then I could use getvalue to find the 3rd value ... but how to find out which value '45' is??