Sort Option 2

[faush]

I have formatted badges in Crystal, and need help sorting.

The name field is one field, which contains first, middle, last. Not everyone has a middle initial.

How do I sort by last name only? I'm using the StringAfterChar formula, but still not producing the results I need.

Ex. of badge names:

JOHN A. DOE
JOHN DOE
JOHN ALLEN DOE

Thanks!

 

[dcm]

faush: Assuming that last name is the last text in the field i.e. you don't also have "Esq." or "B.A. (Hons)" etc. then try the following:

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

this works by using InStrRev() to find the posistion measured in from the left of the last space in the name by reversing it and finding the first occurence! In your examples it would return 8,5,11 respectively. Then Mid() returns the remainder of the string from the next position - i.e. start of lastname - to the end

Hope this helps David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[faush]

Thanks sooooo much, this is finally working!!!!!

You are a lifesaver!

 

[MBNelsonCR]

For what it is worth, I needed this exact thing and it works like a champ!