I have a single field that contains a list of ten numbers that are separated by carriage returns. I need to put each number into a separate field. I would like to do this via a calculation. What would be the best way to do this?

Example:

field_a-d

8

345

12

19

Desired result:

field_a: 8

field_b: 345

field_c:12

field_d:19

field_a = MiddleValues(field_a-d;1;1)

field_b = MiddleValues(field_a-d;2;1)

...etc

I think this may do it: GetValue ( listOfValues ; valueNumber )

field_a = MiddleValues(field_a-d;1;1)

field_b = MiddleValues(field_a-d;2;1)

...etc

Thanks.

the get value solution is easier.

Having the values in separate fields is probably not much better than having all the values in the one field. They should probably be split into related records.