Solved

Functions to Extract Name into Last Name, First Name, and MI

Posted on 2008-06-24
1
4,551 Views
Last Modified: 2013-11-27
Can anyone help me to write three functions in vba access in order to extract the name like the examples below into last name, first name and MI?

the format of the name is "First Name", "MI", "Last Name" and "Suffix".
however, if there is no "MI", the MI part will be missing.

CREE L SHUMPERT
JOSE G. HERNANDEZ JR
MICHELLE HERNANDEZ
CHEYENNE A CORRAL
KENYA AGUINIGA
SHIRLEY MENDEZ-PENA

Thanks!

for example,
one of the name is "JOSE G. HERNANDEZ JR"
lastname(name) = "Hernandez"
firstname(name) = "Jose"
MI(name) = "G"
0
Comment
Question by:IEHP1
1 Comment
 
LVL 2

Accepted Solution

by:
mriz81 earned 250 total points
ID: 21859218
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now