{"id":1355,"date":"2009-04-21T08:30:03","date_gmt":"2009-04-21T16:30:03","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2009\/04\/21\/vbscript-simple-regex-replace\/"},"modified":"2009-04-21T08:30:03","modified_gmt":"2009-04-21T16:30:03","slug":"vbscript-simple-regex-replace","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2009\/04\/21\/vbscript-simple-regex-replace\/","title":{"rendered":"VBScript Simple Regex Replace"},"content":{"rendered":"

Last week I talked about using Regular Expressions in VBScript<\/a>. In that post I focused on simple matching. However, you can also do string replacements using the regular expression object’s Replace()<\/strong> method. You specify a string to replace and its replacement text. I always test the expression to make sure the string exists before doing anything. Here’s a function I use for this task.<\/p>\n

\n
\n
Function<\/span> RegExReplace(strString,strPattern,strReplace)<\/pre>\n
On<\/span> Error<\/span> Resume<\/span> Next<\/span><\/pre>\n
    Dim<\/span> RegEx<\/pre>\n
    Set<\/span> RegEx = New<\/span> RegExp                ' Create regular expression.<\/span><\/pre>\n
    RegEx.IgnoreCase = True<\/span>                ' Make case insensitive.<\/span><\/pre>\n
    RegEx.Global<\/span>=True<\/span>                   'Search the entire String<\/span><\/pre>\n
    RegEx.Pattern=strPattern<\/pre>\n
        <\/pre>\n
    If<\/span> RegEx.Test(strString) Then<\/span>       'Test if match is made<\/span><\/pre>\n
        RegExReplace = regEx.Replace(strString, strReplace)    ' Make replacement.<\/span><\/pre>\n
     Else<\/span><\/pre>\n
         'return original string   <\/span><\/pre>\n
         RegExReplace=strString<\/pre>\n
    End<\/span> If<\/span><\/pre>\n
End<\/span> Function<\/span><\/pre>\n<\/div>\n<\/div>\n
Using the functions from my earlier post it is very simple to make global changes.<\/p>\n
\n
\n
strString=\"'The quick brown dog jumped over the lazy fox'\"<\/span><\/pre>\n
strPattern=\"dog\"<\/span><\/pre>\n
strReplace=\"cat\"<\/span><\/pre>\n
 <\/pre>\n
strRevised=RegExReplace(strString,strPattern,strReplace)<\/pre>\n
 <\/pre>\n
WScript.Echo strString & \" is now \"<\/span> & strRevised<\/pre>\n<\/div>\n<\/div>\n
“Dog” is replaced with “Cat” in this very simple example.  I’ll be back later with a more complex example. <\/p>\n
\n
In the meantime you can download the sample code here.<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Last week I talked about using Regular Expressions in VBScript. In that post I focused on simple matching. However, you can also do string replacements using the regular expression object’s Replace() method. You specify a string to replace and its replacement text. I always test the expression to make sure the string exists before doing anything. Here’s a function I use for this task.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[24],"tags":[463,464,491,996],"class_list":["post-1355","post","type-post","status-publish","format-standard","hentry","category-vbscript","tag-regex","tag-regular-expressions","tag-replace","tag-vbscript"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=1355"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1355\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=1355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=1355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=1355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}