Carl Smith Posted February 1, 2005 Share Posted February 1, 2005 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 More sharing options...
This topic is 6624 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
Already have an account? Sign in here.Sign In Now