I am not sure what fm function I would use to accomplish the following.

I have a text field 'list' containing a list of numbers, separated by returns, that can be as long or short.

5

2

98

34

21

56

34

10

6

I need to make a calculation that will go to one of these numbers in the list replace it with something and then any numbers below the one I changed will be erased from the list.

Example:

I want to replace the number 21 in the list with 14. So the new list will look like:

5

2

98

34

14

I know how to go to the number and replace it but how do I erase all the number below.

Use LeftValues, like:

Let ( [newlist = LeftValues (list ; N - 1 ) ]; // N = number of values to keep

newlist &

Here ya go.

Let ( [

xo =oldValue;

xn = newvalue;

E = Left(list;Position(list & "

Thanks that worked, I was looking at the problem from the wrong end. Trying to delete what was below instead of just saving what I needed.

Thanks again