AnsweredAssumed Answered

filtervalues location

Question asked by greaterthandata on Aug 3, 2017
Latest reply on Aug 3, 2017 by philmodjunk

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