Splitting String in VBA using RegEx

by

To split a string with a regular expression in VBA:

Public Function SplitRe(Text As String, Pattern As String, Optional IgnoreCase As Boolean) As String()
    Static re As Object

    If re Is Nothing Then
        Set re = CreateObject("VBScript.RegExp")
        re.Global = True
        re.MultiLine = True
    End If

    re.IgnoreCase = IgnoreCase
    re.Pattern = Pattern
    SplitRe = Strings.Split(re.Replace(text, ChrW(-1)), ChrW(-1))
End Function

Usage example:

Dim v
v = SplitRe("a,b/c;d", "[,;/]")

More Related Contents:

  1. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  2. Returning a regex match in VBA (excel)
  3. How do I get regex support in Excel via a function, or custom function?
  4. RegEx with Excel VBA on Mac
  5. html parsing of cricinfo scorecards
  6. How to Use/Enable (RegExp object) Regular Expression using VBA (MACRO) in word
  7. Lookbehind on regex for VBA?
  8. Performance difference between looping range vs looping array
  9. SAP Extract into EXCEL via VBA out of memory
  10. How to execute a Bash command only if a Docker container with a given name does not exist?
  11. How do I check if a filename matches a wildcard pattern
  12. Regexp that matches valid regexps
  13. Remove double quotation from write statement in vba
  14. Implement auto-complete feature using MongoDB search
  15. What’s the regex to match anything except a double quote not preceded by a backslash?
  16. How do I loop an excel 2010 table by using his name & column reference?
  17. How to query a MS-Access Table from MS-Excel (2010) using VBA
  18. How to order regular expression alternatives to get longest match?
  19. How to roundup a number to the closest ten?
  20. Convert month name into number
  21. Display a message box with a timeout value
  22. Flutter – Regex in TextFormField
  23. How to improve the speed of VBA macro code?
  24. How to do a non-greedy match in grep?
  25. Understanding positive and negative lookaheads
  26. How to call an Excel VBA Macro from Java Code?
  27. Rename files using regular expression in linux
  28. How to extract domain name from url?
  29. Whats the difference between sed -E and sed -e
  30. How to copy only a single worksheet to another workbook using vba

Leave a Comment