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

    filtervalues location


      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






      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??