|I have a tab delimited file that contains a field that has a fullname. Some of the fullnames have "firstname initial lastname" (ex: Joe B Blow). |
I know very little about VB but would like to figure out how to parse the fullname field into a firstname field (firstname initial) and a lastname field. Example:
firstname = Joe B
lastname = Blow
The file contains 10 thousand records so I'm assuming I would perform the script recursively.