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.

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

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

---

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

=-=-=-=-=-=-=-=-=-=-=-=-=

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.

---

One more question. Please excuse my ignorance. Exactly where do I put the Replace function and how do I get it to run? Thanks.

You can either choose replace from the Records menu, or you can put a Replace script step in a ScriptMaker script.

Chuck

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

---