Jump to content

Parsing Text into Separate Records


This topic is 6995 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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; ";";

Link to comment
Share on other sites

This topic is 6995 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.