There's not a TitleCase function that I'm aware of, however if you are just dealing with names, the code below works for me. My full names are in a "LAST, FIRST" format, and this converts it to a "First Last".
(((LEFT(SUBSTR($Full Name$, (STRSTR($Full Name$, ",") + 2)), 1) + LOWER(SUBSTR($Full Name$, (STRSTR($Full Name$, ",") + 3)))) + " ") + LEFT($Full Name$, 1)) + LOWER(SUBSTR($Full Name$, 1, (STRSTR($Full Name$, ",") - 1)))
It doesn't account for O'Briens or McCallisters, or any other names with caps in the middle, but its close enough for the purposes for which its designed. Hopefully that will give you an idea of what you can do.
Depending on your DB, maybe it has the function you need and you could use Direct SQL. Oracle example:
SELECT INITCAP('FIRST LAST') FROM dual;
Thad
"Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away." - Antoine de Saint-Exupéry
| "T. Dee" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/25/2006 10:17 AM
|
|
I apologize if you received this twice, but the system did not send the email
out.
Is there a command that can convert the text to "title case" - for example
convert JOE SMITH to Joe Smith?
Thanks.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.***
