I am trying to run a script on a field that contains a person last name and first name. I want to copy the last name and put it in it's own field leaving the whole name in tact.

I tried Right words. But that removes it from the name field. And I did insert calculated result but that did not place it in the Last Name field.

As you can tell I am not very good with calculations or scripts. I am sure this is easy but I am at a loss.

Thank you in advance.

Cmack

Please download the file lastfirstcopylastnametonewfield.fp7 and follow these notes:

I used what you recommended, a calculation field ( see database fields ). The only problem is a name like Van Strickland (German) that is a two-word last name. The field name is a calculation so it is not editable. I see this as a problem so I offer this example:

After the record is created, simply click this field “Isolated Last Name 2”, choose 'replace field contents...' command from the records menu, then choose “calculated” button and use the same calculation “LeftWords( Last First; 1 )”. In this way, you may edit the field later. Note that the replace command will change all records in the found set.

Forgive any errors. I created this on the fly for you.

All the best,

Brian

lastfirstcopylastnametonewfield.zip

Thanks Brian. I ran into exactly the problem you described on it was with a hyphenated last name. We have several on staff and it gave me fits. Thank you for your help. I am going to try out your solution perhaps it will get me further.

: ... life gets better and better.