Parsing Text into Separate Records

[Carl Smith]

I have a field of Names formatted as Last Name, First Name(s) (e.g. Williams, John)

Some of these contain more than one Author and I have formatted these with an ampersand (e.g Lennon & Paul McCartney, John).

I have used the Substitute function to replace the Ampersand and the Comma with the Return Character which gives me

Lennon

Paul McCartney

John

What I want to do now is somehow get the entry between the first and second return characters into a new record for some further editing so that I can then put these into a related table.

Hope you can help

[-Queue-]

Middle( text, Position( text, "

[Carl Smith]

This is very much appreciated

Many Thanks

[Slobey]

Sorry to intrude on the string, but I have a field that has text in it separated by a semicolon and I want to put each bit of text in its own record. How would I modify a script to do this?

[-Queue-]

Do you want to create new records for each bit?

Set Field [globaltext; text]

Show All Records

Show Omitted Only

Loop

New Record/Request

Set Field [text; Substitute( MiddleValues( Substitute( globaltext; ";";