Newbies echodoc Posted November 4, 2000 Newbies Share Posted November 4, 2000 Is there a way to get a function (LeftWords) to automatically enter data in existing records (eg on exit from the field)? I am trying LeftWords to retrieve the last name from a name field (eg Smith, John) into a newly created LastName field. thanks. Link to comment Share on other sites More sharing options...
Chuck Posted November 4, 2000 Share Posted November 4, 2000 quote: Originally posted by echodoc: Is there a way to get a function (LeftWords) to automatically enter data in existing records (eg on exit from the field)? I am trying LeftWords to retrieve the last name from a name field (eg Smith, John) into a newly created LastName field. thanks. My advise would be to reverse the logic. Have users enter the first and last names in separate fields, and then have a field calculate the Last, First format. Chuck [This message has been edited by Chuck (edited November 03, 2000).] Link to comment Share on other sites More sharing options...
Newbies echodoc Posted November 4, 2000 Author Newbies Share Posted November 4, 2000 Thanks. Yours certainly sounds like a more elegant solution for new records, but I'm still left with records already entered the old way. quote: Originally posted by Chuck: My advise would be to reverse the logic. Have users enter the first and last names in separate fields, and then have a field calculate the Last, First format. Chuck [This message has been edited by Chuck (edited November 03, 2000).] Link to comment Share on other sites More sharing options...
Kurt Knippel Posted November 4, 2000 Share Posted November 4, 2000 quote: Originally posted by echodoc: Thanks. Yours certainly sounds like a more elegant solution for new records, but I'm still left with records already entered the old way. Use the Replace function on the existing records. Use the normal LeftWords function in the Replace calculation. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Newbies echodoc Posted November 4, 2000 Author Newbies Share Posted November 4, 2000 Thanks! I am going to give it a try. You guys are great! quote: Originally posted by captkurt: Use the Replace function on the existing records. Use the normal LeftWords function in the Replace calculation. Link to comment Share on other sites More sharing options...
Newbies echodoc Posted November 4, 2000 Author Newbies Share Posted November 4, 2000 One more question. Please excuse my ignorance. Exactly where do I put the Replace function and how do I get it to run? Thanks. Link to comment Share on other sites More sharing options...
Chuck Posted November 5, 2000 Share Posted November 5, 2000 You can either choose replace from the Records menu, or you can put a Replace script step in a ScriptMaker script. Chuck Link to comment Share on other sites More sharing options...
Newbies echodoc Posted November 5, 2000 Author Newbies Share Posted November 5, 2000 Thanks! Got it. quote: Originally posted by Chuck: You can either choose replace from the Records menu, or you can put a Replace script step in a ScriptMaker script. Chuck Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8762 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 accountSign in
Already have an account? Sign in here.
Sign In Now