Seperate one field into repeating field

[deego55]

I have a field that is formatted with a list of names, each name appearing on its own line. The number of names varies. Is there a way to seperate each name into a repeating field line?

Example of one field (field A):

F013 Satzinger, John W.

F013 Jackson, Robert B.

F013 Burd, Stephen D.

Would like seperated into repeating field (field ::

FieldB[1] F013 Satzinger, John W.

FiledB[2] F013 Jackson, Robert B.

FieldB[3] F013 Burd, Stephen D.

Can anyone help? Thanks!

[bruceR]

Strongly suggest you don't use repeats.

[deego55]

If not using repeats, is there a way to create a script that can delete a certain line of a field. My ultimate goal is to have a button next to each line item that can delete just that line item such as:

FieldA:

F013 Satzinger, John W. [Delete this item]

F013 Jackson, Robert B. [Delete this item]

F013 Burd, Stephen D. [Delete this item]

[Vaughan]

Put the data into a related table (where it should be!) then use a portal.

[comment]

You should move them into separate records in a related table. Then you can selectively delete portal rows in a portal to the new table.

Here you can find a demo of how to move the data.