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

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

li_Success = 0

li_Success = 0

ls_Subject = "John Anders, +_+_+ Mary Robins $$$$"
ls_Pattern = "\w+\s+\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()

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

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 full match is always in group 0.
    loo_SbTemp.Clear()
    loo_Json.StringOfSb("match[i].group[0].cap",loo_SbTemp)

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

    i = i + 1
loop

// The JSON now has replacement strings:
Write-Debug loo_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.
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 ANDERS, +_+_+ MARY ROBINS $$$$


destroy loo_Sb
destroy loo_Json
destroy loo_SbTemp