#reReplaceNoCase(put_your_var_that_holds_last_name_here,
"([[:alpha:]])((?!(\1|I|V|X){1,3}([[:space:]]|[[:punct:]])*)[[:alpha:]]*)",
"\U\1\L\2\E", "all")#
this will replace all words in a given string
(put_your_var_that_holds_last_name_here) to proper case,
hyphenated
names or not, preserving Roman numerals (i.e. SMITH III, John
will
become Smith III, John ; note that only certain sub-set of
roman
numerals is supported...).
This one does NOT convert Mc and Mac last names correctly,
though.
Credit goes to CFLib and specifically to
http://www.cflib.org/udf.cfm?ID=1384
by Jared Rypka-Hauer... i have just
modified his function a bit and added extra code to account
for Roman
numerals in names...
will keep trying to incorporate Mc and Mac recognition... i
know there
is another udf there for it, but i want to try to do it all
in one regex
instead of a function...
--
Azadi Saryev
Sabai-dee.com
Vientiane, Laos
http://www.sabai-dee.com