| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: InitCap Software or script?
You may be able to find something that will properly Capitalise names
beginning with "Mc", but you'll come unstuck if you want it to do the job
correctly with names beginning with "Mac". OK, it would change MACDONALD to
MacDonald, but it's hard to see how it could do this without incorrectly
changing MACKIE to MacKie, or MACHEN to MacHie... bit semantically sticky,
that problem. Any such software might need to operate in some kind of
verification mode, where you'd accept or reject each proposed Mc/Mac special
case.
Paul
-----Original Message-----
Sent: 10 April 2002 15:38
To: Multiple recipients of list ORACLE-L
I have a fellow DBA that has to do some data cleansing. He is looking for some software that can properly init cap a last name, like McDonald. Obviously, Oracle has an initcap function...
SQL> select initcap('GRABOWY') from dual;
INITCAP
Elapsed: 00:00:00.50
SQL> select initcap('MCDONALD') from dual;
INITCAP(
Elapsed: 00:00:00.10
SQL>
But it does not recognize "special" names like McDonald, so I was wondering
if someone else has encountered this, and what their solution was??
TIA!!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
INET: cgrabowy_at_fcg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 10 2002 - 10:28:36 CDT
 |
 |