I just had a SELECT statement I copied out of Crystal Reports in uppercase. I didn't like the appearance, so I decided to make the fields look Like.this. Rather than go crazy with find-replace, I decided to see if I could come up with a regular expression that would do it for me. I finally came up with this: not ideal, but a better place to start than all-upper...
ON KEY LABEL f6 _CLIPTEXT = RegExp(_CLIPTEXT, "([A-Z])([A-Z]+)\.([A-Z])([A-Z]+)", 1, "\1\L\2.\3\4") I thought I was going to have to go line-by-line, but I was able to select the whole statement and have it run as expected. See Craig Boyd's blog for RegExp.fll, if you don't already have it: http://preview.tinyurl.com/2gxob7 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
