(PowerBuilder) 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

integer li_rc
integer li_Success
string ls_Subject
string ls_Pattern
oleobject loo_Sb
oleobject loo_Json
integer li_TimeoutMs
integer li_NumMatches
integer li_FirstNameIdx
integer li_LastNameIdx
oleobject loo_SbTemp
integer i

li_Success = 0

ls_Subject = "John Anders, +_+_+ Mary Robins $$$$"
ls_Pattern = "(?<first>\w+)\s+(?<last>\w+)"

loo_Sb = create oleobject
li_rc = loo_Sb.ConnectToNewObject("Chilkat.StringBuilder")
if li_rc < 0 then
    destroy loo_Sb
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_Sb.Append(ls_Subject)

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.EmitCompact = 0

li_TimeoutMs = 2000
li_NumMatches = loo_Sb.RegexMatch(ls_Pattern,loo_Json,li_TimeoutMs)
if li_NumMatches < 0 then
    // Probably an error in the regular expression.
    // Suggestion: Use AI to help create and/or diagnose regular expressions.
    Write-Debug loo_Sb.LastErrorText
    destroy loo_Sb
    destroy loo_Json
    return
end if

// Examine the matches:
Write-Debug loo_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 $$$$

li_FirstNameIdx = loo_Json.IntOf("named.first")
li_LastNameIdx = loo_Json.IntOf("named.last")

loo_SbTemp = create oleobject
li_rc = loo_SbTemp.ConnectToNewObject("Chilkat.StringBuilder")

i = 0
li_NumMatches = loo_Json.SizeOfArray("match")
do while i < li_NumMatches

    loo_Json.I = i

    // The replacement string for the first name will be all uppercase.
    loo_Json.J = li_FirstNameIdx
    loo_SbTemp.Clear()
    loo_Json.StringOfSb("match[i].group[j].cap",loo_SbTemp)
    loo_SbTemp.ToUppercase()
    loo_Json.UpdateSb("match[i].group[j].rep",loo_SbTemp)

    // Append "on" to the last name.
    loo_Json.J = li_LastNameIdx
    loo_SbTemp.Clear()
    loo_Json.StringOfSb("match[i].group[j].cap",loo_SbTemp)
    loo_SbTemp.Append("on")
    loo_Json.UpdateSb("match[i].group[j].rep",loo_SbTemp)

    i = i + 1
loop

// The JSON now has replacement strings:
Write-Debug loo_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.
li_Success = loo_Sb.RegexReplace(loo_Json)
if li_Success = 0 then
    Write-Debug loo_Sb.LastErrorText
    destroy loo_Sb
    destroy loo_Json
    destroy loo_SbTemp
    return
end if

Write-Debug "Result after doing replacements:"
Write-Debug loo_Sb.GetAsString()

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


destroy loo_Sb
destroy loo_Json
destroy loo_SbTemp