I have a field named FullName from which I need to extract the last name into a separate field. I used the Calculatoin in the manual to do this when the field used the format of "FIrstName LastName" but we had to change the field to display "First Last, Title."

Can anyone help with a Calc to do this? A comma always follows the last name.

i.e.,

John Smith, MD --> Smith

Thanks!

We just had this topic.

See if this Link doesn't answer your questions. Be sure to follow any links, and download the example file(s)

HTH

Lee

Thanks-is there an easier way using Position and one of the Word functions?

It will break with just about any entry other than one word last names.

RightWords (YourField; 1)

Edited December 21, 200718 yr by Guest

Try:

Let ( [

len = Length ( FullName ) ;

end = Position ( FullName ; "," ; len ; - 1 ) ;

start = Position ( FullName ; " " ; end ; - 1 ) + 1

] ;

Middle ( FullName ; start ; end - start )

)

thanks--stupid question, though...where does the Let function go in the Calc for the lastname field?

In the calculation formula box? Or perhaps I don't understand your question.

I haven't used the Let command before.

Would I just enter what you posted into the Calc definition for the LastName field?

Yes. Let() is a function like any other function.

...where does the Let function go in the Calc for the lastname field?

Yes.

Works perfectly--thanks so much!!