jennifer george
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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER