Why not use SQL to "decapitalize" or setting "Proper Case". It would be
quite easy using INITCAP().
Initial Letter Upper Case
function INITCAP(<string_or_column>)
SELECT INITCAP('PETER WHITING') FROM dual;
would come out Peter Whiting
Of course you have "McPhie" type of last names, in which you could more
particular about. In that instance, you could use TCL to tweak the
strings
a bit more:
if {[string match "Mc[a-z]" $lastname]} {
PUT STRING MANIPULATION HERE
}
----- Original Message -----
From: "Peter Whiting" <[EMAIL PROTECTED]>
To: "LDS Open Source Software" <[email protected]>
Sent: Friday, March 03, 2006 9:44 PM
Subject: Re: [Ldsoss] ward list export
| On Fri, Mar 03, 2006 at 08:32:03PM -0800, Tony Fenleish wrote:
| > What type of database are you running?
|
| oracle
|
| >
| >
| > ----- Original Message -----
| > From: "Peter Whiting" <[EMAIL PROTECTED]>
| > To: <[email protected]>
| > Sent: Friday, March 03, 2006 4:10 PM
| > Subject: [Ldsoss] ward list export
| >
| >
| > | We'd like to add the option to export the ward list from the unit
| > | website either as a csv file or as vcards.
| > |
| > | Issues/questions:
| > |
| > | 1. Most of the text is stored in caps. We plan on just leaving
| > | it as-is for simplicity. If someone wants to propose a clean,
| > | simple, safe way to decapitalize in TCL, feel free to send it my
| > | way.
| > |
| > | 2. For the csv export, what should each row look like?
| > |
| > | a) name, email, phone, addr (one row for every member of the ward) -
| > this
| > | is the easiest to do but might not be as useful.
| > | b) family, head of household, head of household email, phone, addr
| > | (one row for each family) - this is about as easy to do as the
above.
| > | c) family, head of household, head of household email, spouse,
spouse
| > email,
| > | phone, addr (one row for each family)
| > | d) everything above, plus one large field containing all of the
| > children's
| > | names, and emails
| > | e) similar to above, but each child would get their own pair of
columns
| > | (name and email) making each row vary in the number of columns -
this
| > | would imply that the children are going to be at the end of the
| > record.
| > |
| > | Sorry we can't do unique phone numbers per person - it isn't
supported
| > in
| > the
| > | current database.
| > |
| > | 3. Similar questions for vcard...
| > |
| > | pete
| > |
| > | _______________________________________________
| > | Ldsoss mailing list
| > | [email protected]
| > | http://lists.ldsoss.org/mailman/listinfo/ldsoss
| > |
| > |
| >
| >
| > __________________________________________________
| > Do You Yahoo!?
| > Tired of spam? Yahoo! Mail has the best spam protection around
| > http://mail.yahoo.com
| > _______________________________________________
| > Ldsoss mailing list
| > [email protected]
| > http://lists.ldsoss.org/mailman/listinfo/ldsoss
| _______________________________________________
| Ldsoss mailing list
| [email protected]
| http://lists.ldsoss.org/mailman/listinfo/ldsoss
|
|
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
Ldsoss mailing list
[email protected]
http://lists.ldsoss.org/mailman/listinfo/ldsoss
