First/Middle/Last Name Formatting and Verification
This algorithm processes each name field (first, last, middle) and normalizes the constituent-submitted content in properly capitalized and punctuated name strings.
Below is a functional description of the algorithm.
Remove whitespace (leading, trailing, duplicate) from the name string:
"mackey " => "mackey", "de la reza" => "de la reza
If the name string is mixed case, do not change the capitalization:
"lavelle" will be corrected; "LaVelle" will not.
After performing a lookup against the keys listed in the FORMAT_NAME_EXCEPTIONS table and ignoring differences in capitalization, replace the current name string with the match, if matches are found, in the FORMAT_NAME_EXCEPTIONS table and do not process this name string further.
"mackey" => "Mackey"; no further processing performed.
Capitalize the first letter in each word in the string as delimited by space, hyphen, or period:
"de la reza" => "De La Reza" , "st.clair" => "St.Clair"
Apply rules defined in the FORMAT_NAME_RULES table to the resulting string:
"De La Reza" => "de la Reza" , "O'hara" => "O'Hara", "Von Den Linden" => "von den Linden"
After each name string component of the constituent input has been processed by the above algorithm, the properly formatted and validated name strings are written to the constituent record.
Exceptions to Name Cleaner Rules Actions (FORMAT_NAME_EXCEPTIONS)
D'Amico
DaCosta
DaSilva
DaVeiga
DeAngelis
DeAngelo
DeBartolo
DeBell
DeBenedictis
DeBerry
DeBlasio
DeBoer
DeBonis
DeBord
DeBruin
DeCamp
DeCarlo
DeCaro
DeChant
DeChirico
DeCicco
DeClue
DeCosta
DeCuir
DeFalco
DeFazio
DeFelice
DeFeo
DeFilippis
DeFilippo
DeFoe
DeFord
DeForest
DeFrancesco
DeFranco
DeGarmo
DeGennaro
DeGolyer
DeGraff
DeGraw
DeGregorio
DeGroat
DeGroot
DeHaan
DeHart
DeHaven
DeJesus
DeJohn
DeJong
DeLacy
DeLancey
DeLapp
DeLaura
DeLaurentis
DeLay
DeLeo
DeLeon
DeLisle
DeLoach
DeLong
DeLorenzo
DeLorey
DeLozier
DeLuca
DeLucia
DeMaio
DeMarco
DeMaria
DeMars
DeMartini
DeMartino
DeMasi
DeMatteo
DeMay
DeMello
DeMeo
DeMeritt
DeMichele
DeMille
DeMoss
DeMott
DeMuth
DeNicola
DePalma
DePaolo
DePasquale
DePaula
DePew
DePhillips
DePriest
DePuy
DeRosa
DeRose
DeRosier
DeRouen
DeSalvo
DeSantis
DeSanto
DeSena
DeShazo
DeSilva
DeSimone
DeSoto
DeSouza
DeSpain
DeStefano
DeVaughn
DeVault
DeVere
DeVille
DeVincenzo
DeVita
DeVito
DeVoe
DeVore
DeVos
DeVries
DeWald
DeWalt
DeWees
DeWeese
DeWitt
DeWolf
DeYoung
DelGiudice
DelGreco
DelVecchio
DellaLoggia
DesJardins
DesLauriers
DiBello
DiBenedetto
DiBernardo
DiBiase
DiBona
DiCamillo
DiCarlo
DiCicc
DiCostanzo
DiDomenico
DiFazio
DiFiore
DiFrancesco
DiGiacomo
DiGioia
DiGiorgio
DiGiovanni
DiGrazia
DiJulio
DiLallo
DiLeo
DiLorenzo
DiLoreto
DiMaggio
DiMambro
DiMarco
DiMaria
DiMartino
DiMatteo
DiMattia
DiMauro
DiMeglio
DiNardo
DiNatale
DiPalma
DiPaola
DiPaolo
DiPasquale
DiPierro
DiPietro
DiRocco
DiSalvo
DiSanto
DiStefano
DiTullio
DiVito
DuBois
DuBose
DuFresne
DuPre
FitzGerald
LaBarbera
LaBarge
LaBarre
LaBella
LaBelle
LaBianca
LaBonte
LaBounty
LaBranche
LaBrecque
LaBrie
LaCasse
LaChance
LaChapelle
LaClair
LaCour
LaCroix
LaCrosse
LaDue
LaFave
LaFever
LaFlamme
LaFleur
LaFollette
LaFon
LaFontaine
LaForce
LaForest
LaForge
LaFrance
LaFreniere
LaGorga
LaGrone
LaGuardia
LaLiberte
LaLonde
LaManna
LaMantia
LaMarca
LaMarche
LaMonica
LaMontagne
LaMothe
LaMotte
LaPlaca
LaPlant
LaPlante
LaPoint
LaPointe
LaPorta
LaPorte
LaPrade
LaReau
LaRocca
LaRocco
LaRoche
LaRochelle
LaRock
LaRocque
LaRoe
LaRosa
LaRose
LaRue
LaSalle
LaTorre
LaTour
LaValle
LaValley
LaVerne
LeAnn
LeBaron
LeBeau
LeBlanc
LeBoeuf
LeBrun
LeClair
LeClaire
LeCompte
LeCroy
LeDoux
LeDrew
LeDuc
LeFevre
LeGrand
LeJeune
LeMaire
LeMaster
LeMasters
LeMay
LePage
LeRoux
LeRoy
LeSage
LeTourneau
LeVan
LeVasseur
LeeAnn
LoCicero
LoGerfo
LoPreste
LoPresti
LuAnn
Mac
Macaluso
Macartney
Macaulay
Macauley
Maccarone
Macchia
Mace
Maceda
Macedo
Macek
Macey
Mach
Machacek
Machado
Machen
Machin
Macias
Maciejewski
Mack
Mackay
Macke
Mackel
Mackey
Mackie
Mackin
Macklin
Macko
Macky
Macomber
Macon
Macri
Macy
O'Brien
O'Connell
O'Connor
O'Dell
O'Donnell
O'Grady
O'Hara
O'Keefe
O'Leary
O'Leyar
O'Loughlin
O'Malley
O'Neal
O'Neil
O'Neill
O'Rourke
O'Sullivan
StClair
StJohn
VanBuren
VanBuskirk
VanDyke
VanEtten
VanHorn
VanHouten
VanLandingham
VanPelt
VanSickle
VanWormer
deAndrade
deForest
Appendix B. Name Cleaner Rules (FORMAT_NAME_RULES)
Capitalize the letter following Mac
Capitalize the letter following Mc
Capitalize the letter following a single letter and an apostrophe (Hebrew and Arabic transcriptions use apostrophe medially for glottal and pharyngeal stops; Russian transliteration uses it for myagkiy znak and sometimes palatalized consonants. Luminate does not capitalize the following letter; therefore, this rule produces "O'Hara" but "Ye'or" instead of incorrect "Ye'Or".)
ab Welsh ab is lowercase
ad Arabic ad is lowercase
al Arabic al is lowercase
ap Welsh ap is lowercase
as Arabic as is lowercase
d' French d' is lowercase
da Portugese da is lowercase
de French, Dutch, and Spanish de is lowercase
den German den is lowercase
der German/Dutch der is lowercase
dos Portuguese dos is lowercase
ibn Arabic ibn is lowercase
la Spanish/French la is lowercase
n Arabic/Gaelic n' is lowercase
ten Dutch ten is lowercase
ul Urdu ul is lowercase
und German und is lowercase
van Dutch van is lowercase
von German von is lowercase
y Spanish y is lowercase
zu German zu is lowercase