PARSENAME

Description

Returns the specified name token from a name line.

Syntax

PARSENAME ( TextSourceField, "name_token" )

Parameter	Description
TextSourceField	The string from which to return a name token.
name_token	The identifier for the name token to return. Use one of the following values: P — Prefix F — First name M — Middle name L — Last name S — Suffix D — Professional degree

Remarks

A valid name should include a first name and last name, and may also include a middle name, prefix, suffix or professional degree. Listed below are the prefixes, suffixes, and professional degrees the function recognizes.

Prefixes

&	Dr	Mlle	Mr.	Rev
and	Dr.	Mlle.	Mrs	Rev.
Attorney	Frau	Mm	Mrs.	Reverend
Atty	Herr	Mm.	Ms	Senor
Atty.	Mej	Mme	Ms.	Senora
Dhr	Mej.	Mme.	Mw	Sr
Dhr.	Miss	Monsieur	Mw.	Sr.
Doctor	Mister	Mr	Professor	Sra.
Dona

Suffixes

I	Esq
II	Esq.
III	Jr
IV	Jr.
V	Sr.

Degrees

B.A.	C.P.A.	MBA
BA	CPA	M.D.
B.S.	D.D.S.	MD
BS	DDS	Ph.D.
C.F.P.	J.D.	PhD
CFP	JD	R.Ph.
C.L.U.	M.B.A.	RPh

Examples

This function returns John:

PARSENAME("Mr. John T. Smith Jr., PhD", "F")

This function returns Smith:

PARSENAME("John T Smith", "L")