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