Parsing data from a single field into multiple fields?

[HALBURN]

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

[doughemi]

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

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

...etc

[HALBURN]

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

[HALBURN]

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

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

...etc

Thanks.

[Aussie John]

the get value solution is easier.

[Vaughan]

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.