(VBScript) Regular Expression Replace Full Matches

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 fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

success = 0

subject = "John Anders, +_+_+ Mary Robins $$$$"
pattern = "\w+\s+\w+"

set sb = CreateObject("Chilkat.StringBuilder")
success = sb.Append(subject)

set json = CreateObject("Chilkat.JsonObject")
json.EmitCompact = 0

timeoutMs = 2000
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.
    outFile.WriteLine(sb.LastErrorText)
    WScript.Quit
End If

' Examine the matches:
outFile.WriteLine(json.Emit())

' {
'   "match": [
'     {
'       "group": [
'         {
'           "cap": "John Anders",
'           "idx": 0,
'           "len": 11
'         }
'       ]
'     },
'     {
'       "group": [
'         {
'           "cap": "Mary Robins",
'           "idx": 19,
'           "len": 11
'         }
'       ]
'     }
'   ]
' }

set sbTemp = CreateObject("Chilkat.StringBuilder")

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

    json.I = i

    ' The full match is always in group 0.
    sbTemp.Clear 
    success = json.StringOfSb("match[i].group[0].cap",sbTemp)

    ' Indicate that we wish to replace the full match with it's value converted to uppercase.
    success = sbTemp.ToUppercase()
    success = json.UpdateSb("match[i].group[0].rep",sbTemp)

    i = i + 1
Loop

' The JSON now has replacement strings:
outFile.WriteLine(json.Emit())

' {
'   "match": [
'     {
'       "group": [
'         {
'           "cap": "John Anders",
'           "idx": 0,
'           "len": 11,
'           "rep": "JOHN ANDERS"
'         }
'       ]
'     },
'     {
'       "group": [
'         {
'           "cap": "Mary Robins",
'           "idx": 19,
'           "len": 11,
'           "rep": "MARY ROBINS"
'         }
'       ]
'     }
'   ]
' }

' Call RegexReplace to update the StringBuilder with the replacements.
success = sb.RegexReplace(json)
If (success = 0) Then
    outFile.WriteLine(sb.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine("Result after doing replacements:")
outFile.WriteLine(sb.GetAsString())

' Result after doing replacements:
' JOHN ANDERS, +_+_+ MARY ROBINS $$$$

outFile.Close