[TxMt] Re: How to target specific fields for a "Change to Titlecase" in SQL

[John Stephens]

I posted the query below a few days ago and I'm wondering if I said  
something offensive-- I haven't heard any responses. My situation  
isn't dire, but if I violated list etiquette in some way, I'd like to  
learn from my mistake. If the question isn't within the scope of the  
list, that would be useful to know too.

Thanks!


> Hi, I'm new.
>
> I'm working on a custom Textpattern installation and my client has
> entered a massive amount of text data in certain fields using
> UPPERCASE. He wants the text displayed in Title Case instead, and he
> doesn’t want to manually change it. I can easily use the style
> declaration "text-transform: capitalize;" for these elements, but my
> client would very much prefer formal title case in which words such
> as “the,” “of,” “and,” and “for” are not capitalized. (I see that
> Textmate’s "Convert to Titlecase" command in the "Text" menu does
> this correctly.)
>
> I have made a mysql dump of the database, but I'm not sure how to
> isolate the appropriate data for a text transformation. Here is how
> each individual record is formatted in the database:
>
> (91,'2008-08-03 05:20:57','author-username','2008-08-03
> 05:26:33','','UPPERCASE DATA','','','','','','','UPPERCASE-DATA','',
> 0,'Comment',0,4,1,1,'section-name','','lowercase-data','lowercase-
> data','','','','','','','','','','','UPPERCASE DATA','','lowercase-
> data','3p344629nn178n874sp2s222s0q3n072','2008-08-03')
>
> The mysql dump also contains uppercase terms such as "DROP TABLE IF
> EXISTS" and lowercase terms like "datetime" and "varchar" that I
> _don't_ want changed. Is there a simple way to target just the
> UPPERCASE DATA fields enclosed in single quotes for a massive "Covert
> to Titlecase"?
>
> I welcome advice from regular expression fu-masters and Textmate  
> adepts!
>
> Thanks in advance!
> John Stephens