PARSENAME
Syntax
PARSENAME (TextSourceField, "name_token")
Description
Returns the specified name token from name line.
Arguments
| TextSourceField |
The string from which to return a name token. |
| Name_token | The identifier for the name token to return. Following are the valid values for this argument.
P - Prefix F - First Name M - Middle Name L - Last Name S - Suffix D - Professional degree |
Returns
The name token, or portion of the original TextSourceField.
Remarks
A valid name should include a first name and last name, and may also included a middle name, prefix, suffix or professional degree.
When identifying prefixes, suffixes, and professional degrees PARSNAME is not case-sensitive.
Examples
The following example:
PARSENAME("Mr. John T. Smith Jr., PhD", "F")
Returns: John
The following example:
PARSENAME("John T. Smith", "L")
Returns: Smith
Prefixes, Suffixes, And Professional Degrees Recognized By PARSENAME
The table shown below is created as a Lookup table in TIBCO Cloud™ Integration - Connect the first time the PARSENAME function is included in a saved flow. This table is used to recognize specific text that should not be included as part of a first, middle, or last name. Lookup tables can be edited from the Lookup Tables page in TIBCO Cloud™ Integration - Connect. See Adding Or Editing A Lookup Table.
| Prefixes | Suffixes | Degrees |
|---|---|---|
| & | I | B.A |
| and | II | B.S. |
| Attorney | III | BA |
| Atty | IV | BS |
| Atty. | V | C.F.P. |
| Dhr | Esq | C.L.U. |
| Dhr. | Esq. | C.P.A. |
| Doctor | Jr | CFP |
| Dr | Jr. | CLU |
| Dr. | Sr. | CPA |
| Frau | D.D.S. | |
| Herr | DDS | |
| Mej | J.D. | |
| Mej. | JD | |
| Miss | M.B.A. | |
| Mister | M.D. | |
| Mlle | MBA | |
| Mlle. | MD | |
| Mm | Ph.D. | |
| Mm. | PhD | |
| Mme | R.Ph. | |
| Mme. | RPh | |
| Monsieur | ||
| Mr | ||
| Mr. | ||
| Mrs | ||
| Mrs. | ||
| Ms | ||
| Ms. | ||
| Mw | ||
| Mw. | ||
| Professor | ||
| Rev | ||
| Rev. | ||
| Reverend | ||
| Señor | ||
| Señora | ||
| Señorita | ||
| Sr | ||
| Sr. | ||
| Sra | ||
| Sra. | ||
| da | ||
| de | ||
| del | ||
| des | ||
| di | ||
| dos | ||
| la | ||
| le | ||
| mac | ||
| mc | ||
| Saint | ||
| St | ||
| St. | ||
| van | ||
| van den | ||
| van der | ||
| vander | ||
| von | ||
| von der |