Robertson-Ravo, Neil (RX) wrote: > But obviously, Ben is a RegEx master!
It's only obvious because I say it so often. Uppercasing words is easy. Knowing when to is harder. I wrote a titlecap UDF once, but my boss ended up going through the data and fixing it manually, because there were so many inconsistencies that had to be fixed. Mostly, there were problems with last names that have two parts, one lowercase and one uppercase (ie van Buren). The problem is the same here. If it's just the numbers that should be capped, it's easier to just write a routine to uppercase them. This basically applies unless you know the wording will *always* be exactly the same (ie is computer-generated) and, in that case, it seems to me it's easier to teach the generator to uppercase the correct words to begin with. --Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=51 Message: http://www.houseoffusion.com/lists.cfm/link=i:21:935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/21 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:21 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.21 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
