Text Formatting – Insert Blank Before Capital Letter
Inserts a space before each capital letter in a string where appropriate to separate concatenated words.
This function uses a regular expression to detect transitions between lowercase and uppercase letters, or between consecutive uppercase letters followed by lowercase (e.g., “HTMLParser” becomes “HTML Parser”).
VB
Public Function InsertBlankBeforeCapitalLetter(TextToProcess As String) As String
Return Regex.Replace(TextToProcess, "([a-z](?=[A-Z])|[A-Z](?=[A-Z][a-z]))", "$1 ")
End Function