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 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!