(Visual Basic 6.0) Regular Expression Replace Capture Groups

See more Regular Expressions Examples

Note: Chilkat uses PCRE2. See PCRE2 Regular Expressions
Also see: PCRE2 Performance

Note: This example requires Chilkat v11.1.0 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim success As Long
success = 0

Dim subject As String
subject = "John Anders, +_+_+ Mary Robins $$$$"
Dim pattern As String
pattern = "(?<first>\w+)\s+(?<last>\w+)"

Dim sb As New ChilkatStringBuilder
success = sb.Append(subject)

Dim json As New ChilkatJsonObject
json.EmitCompact = 0

Dim timeoutMs As Long
timeoutMs = 2000
Dim numMatches As Long
numMatches = sb.RegexMatch(pattern,json,timeoutMs)
If (numMatches < 0) Then
    ' Probably an error in the regular expression.
    ' Suggestion: Use AI to help create and/or diagnose regular expressions.
    Debug.Print sb.LastErrorText
    Exit Sub
End If

' Examine the matches:
Debug.Print json.Emit()

' There are 2 matches:

' {
'   "named": {
'     "first": 1,
'     "last": 2
'   },
'   "match": [
'     {
'       "group": [
'         {
'           "cap": "John Anders",
'           "idx": 0,
'           "len": 11
'         },
'         {
'           "cap": "John",
'           "idx": 0,
'           "len": 4
'         },
'         {
'           "cap": "Anders",
'           "idx": 5,
'           "len": 6
'         }
'       ]
'     },
'     {
'       "group": [
'         {
'           "cap": "Mary Robins",
'           "idx": 19,
'           "len": 11
'         },
'         {
'           "cap": "Mary",
'           "idx": 19,
'           "len": 4
'         },
'         {
'           "cap": "Robins",
'           "idx": 24,
'           "len": 6
'         }
'       ]
'     }
'   ]
' }

' To replace capture groups, write code to examine each capture group within
' each match, and provide a replacement string.
' Then call RegexReplace.

' For example, let's capitalize the first names, and add append "on" to the last name.
' After doing replacements, we should get:  JOHN Anderson, +_+_+ MARY Robinson $$$$

Dim firstNameIdx As Long
firstNameIdx = json.IntOf("named.first")
Dim lastNameIdx As Long
lastNameIdx = json.IntOf("named.last")

Dim sbTemp As New ChilkatStringBuilder

Dim i As Long
i = 0
numMatches = json.SizeOfArray("match")
Do While i < numMatches

    json.I = i

    ' The replacement string for the first name will be all uppercase.
    json.J = firstNameIdx
    sbTemp.Clear 
    success = json.StringOfSb("match[i].group[j].cap",sbTemp)
    success = sbTemp.ToUppercase()
    success = json.UpdateSb("match[i].group[j].rep",sbTemp)

    ' Append "on" to the last name.
    json.J = lastNameIdx
    sbTemp.Clear 
    success = json.StringOfSb("match[i].group[j].cap",sbTemp)
    success = sbTemp.Append("on")
    success = json.UpdateSb("match[i].group[j].rep",sbTemp)

    i = i + 1
Loop

' The JSON now has replacement strings:
Debug.Print json.Emit()

' {
'   "named": {
'     "first": 1,
'     "last": 2
'   },
'   "match": [
'     {
'       "group": [
'         {
'           "cap": "John Anders",
'           "idx": 0,
'           "len": 11
'         },
'         {
'           "cap": "John",
'           "idx": 0,
'           "len": 4,
'           "rep": "JOHN"
'         },
'         {
'           "cap": "Anders",
'           "idx": 5,
'           "len": 6,
'           "rep": "Anderson"
'         }
'       ]
'     },
'     {
'       "group": [
'         {
'           "cap": "Mary Robins",
'           "idx": 19,
'           "len": 11
'         },
'         {
'           "cap": "Mary",
'           "idx": 19,
'           "len": 4,
'           "rep": "MARY"
'         },
'         {
'           "cap": "Robins",
'           "idx": 24,
'           "len": 6,
'           "rep": "Robinson"
'         }
'       ]
'     }
'   ]
' }

' Call RegexReplace to update the StringBuilder with the replacements.
success = sb.RegexReplace(json)
If (success = 0) Then
    Debug.Print sb.LastErrorText
    Exit Sub
End If

Debug.Print "Result after doing replacements:"
Debug.Print sb.GetAsString()

' Result after doing replacements:
' JOHN Anderson, +_+_+ MARY Robinson $$$$