I need help parsing a string in my VB6 application. I have a list of names formatted in the following manner:
LAST NAME, FIRST NAME Middle Initial
Smith, Olivia R
I want to parse the name so that the LAST NAME, FIRST NAME, and Middle Initial are placed in the following 3 variables: strLastName, strFirstName, strMiddleInit (if it is there). How can I do this?
Thanks in advance,