I have a Crystal Report that has a field with a persons entire name. Some people have "firstName middleInitial lastName", "firstName lastName", "firstName1 firstName2 middleName1 middleName2 lastName".
The entries all vary in length, but all I need is the last name. The last name is always preceded by a space. How do I split the entry and capture just that part of the string following the last space?
Any help is greatly appreciated.