Skip to sidebar Skip to content
Ipercube Technical
Jack of all trades, master of none
Date: Time: - Stardate:
Welcome, Log in by clicking  Here!
SS64
MDN
Stack
Code
GitHub
Wiki
Convert
V Studio
  • Home
  • VB Functions
    • Access Functions
    • Assembly Info
    • Color/Image Functions
    • Data Table Functions
    • Email Functions
    • Active Directory Functions
    • LDAP Functions
    • Excel Functions
    • Logging Functions
    • Source Code Retrieval
    • String Functions
    • Sql Functions
    • Object Utilities Functions
    • System and Utilities
    • Utility Forms
  • VB Classes
    • Environment Variables Helper
  • ABAP
    • ABAP Reports
    • ABAP HTTP Functions
Ipercube Technical
  • Home
  • VB Functions
    • Access Functions
    • Assembly Info
    • Color/Image Functions
    • Data Table Functions
    • Email Functions
    • Active Directory Functions
    • LDAP Functions
    • Excel Functions
    • Logging Functions
    • Source Code Retrieval
    • String Functions
    • Sql Functions
    • Object Utilities Functions
    • System and Utilities
    • Utility Forms
  • VB Classes
    • Environment Variables Helper
  • ABAP
    • ABAP Reports
    • ABAP HTTP Functions

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

Posted by ipercube


© 2026 Ipercube Design