I can't help you with your question (not that great with regex's) but I don't think you offended anyone, sometimes questions slip through unanswered. not sure why.

On Mon, Aug 11, 2008 at 12:16 PM, John Stephens <john@designop.us> wrote:
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.


> 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

textmate mailing list