Extracting Last Name from a Field 1

[EricMa]

I have a single field in my report which contains First Name and Last Name (John Smith). I would like to extract the last name so I can group the report by last name. Can someone give me some pointers on creating this formula?

http://www.crystaldecisions.com

is currently down. Thanks.

 

[Nuffsaid]

Hi There,

Check out the "Extract String" function.

Nuffsaid.

 

[Hm786]

Hi,

Try using this formula, it worked for me.

Mid(Name,InStrRev(Name," &quot+1)

Hamida

 

[FoxG]

Hi,

Note that this formula will not cater for double barreled names, eg. Fred Palmer Smith.

There is no simple way of stripping off surnames correctly unless either 3 separate fields are used or names are held as Surname,Forename Middlename(s)

Even with this format you have to be careful where no middlename exists!

Hth,
Geoff

 

[chelseatech]

With CR8, you could also use InstrRev to search for the last space in someone's name -
but it wouldn't handle people with two/multiple word Surnames von xxx, van der xxx, te xx, le xxx, etc. (Ie. foreigners)

http://www.chelseatech.co.nz

Editor of Crystal Clear

 

[Varco]

Try using the StrReverse function on the name field first, which will reverse the string and put the last name at the start of the string. Then use the functions noted in previous responses to extract just the last name. Once done, use the StrReverse again if needed to flip the name again for display. Jim Varco
Varco Consulting
jimvarco@worldnet.att.net