Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

function in existing records


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

Recommended Posts

  • Newbies

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

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

  • Newbies

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

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

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 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.