extracting last name

[denno]

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!

[Lee Smith]

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

[denno]

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

[Lee Smith]

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

RightWords (YourField; 1)

Edited December 21, 2007 by Guest

[comment]

Try:

Let ( [

len = Length ( FullName ) ;

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

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

] ;

Middle ( FullName ; start ; end - start )

)

[denno]

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

[comment]

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

[denno]

I haven't used the Let command before.

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

[comment]

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

[Lee Smith]

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

Yes.

[denno]

Works perfectly--thanks so much!!