http://snipplr.com/users/warwick-datum-process Recent snippets posted on Snipplr.com en-us Fri, 24 May 2013 07:12:37 GMT http://snipplr.com/view/65842/splitting-the-words-in-a--titlecase-string-without-using-regular-expressions-for-vba/ Using VBA (Visual Basic for Applications) in MS Access, I needed to convert TitleCase to lower\_case, but did not have the regex enqine that's available in VB Script. This solution, based on a simple state machine model, splits the words in the string (converting to lower-case is trivial after that). It treats a block of upper-case letters as a single word, but the last letter of that block is the first letter of the next word; e.g., "VBAIsLame" becomes "VBA Is Lame". Because of this behaviour, if you subsequently convert to lower-case, you cannot reliably convert back to the original (all-upper-case words are indistinguishable from title-case words). To resolve this potential ambiguity, you can supply an "upper\_case\_indicator" that will be inserted before each capital letter that isn't the start of a word. So `TitleCaseSplit("VBAIsLame", "_", "-")` returns "V-B-A\_Is\_Lame".

]]> Thu, 28 Jun 2012 03:16:13 GMT http://snipplr.com/view/65842/splitting-the-words-in-a--titlecase-string-without-using-regular-expressions-for-vba/