Textproblem

[Jokez]

Hi!

I have a field that contains a calculation that gets all values from a valuelist. The list is the following: 1,2,3,4,5 and so on.... Now I want to take out the first value and do something with that, then the next and then next until the end of the list. How do I do that?

// Jocke

[mr_vodka]

Try taking a look at the Position function and the Left, Middle, Right functions as well.

If it is a value list, it should be seperated by the '¶' delineator.

[Fenton]

And LeftValues(), MiddleValues(), RightValues(). Convenient for return-separated lists. Inconvenient because they return the carriage return also; use Substitute to remove it.