Link to home
Start Free TrialLog in
Avatar of jennifer george
jennifer georgeFlag for United States of America

asked on

How can I parse First, Middle Initial, Last name in Crystal Reports with inconsistent data?

I am trying to parse a Full Name field into First, Last, & Middle Initial in Crystal Reports.  I am able to get the Last name, but am having issues getting the first & middle initial.  The issue lies in the data. (And my lack of knowledge).  The data looks like:

Smith; John
Smith; John D.
Smith; John D
Smith; John David

I was able to parse the last name, but I am unsure how to get the first & middle separated.  I can get them both, but I can't figure out how to get them separated when the data is inconsistent.  
Any help would be greatly appreciated!  Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jennifer george

ASKER

Worked perfect!  Thank you!