Regular Expression در پیدا کردن یا جایگزین کردن رشته در متن

لطفا کامل متن لینک زیر را مطالعه بفرمائید در کدهای vba حتما نیاز خواهد شد 

Regular_expression

Regular expressions are patterns used to match character combinations in strings. In JavaScript, regular expressions are also objects. These patterns are used with the exec() and test() methods of RegExp , and with the match() , matchAll() , replace() , replaceAll() , search() , and split() methods of String .

RegEx stands for “Regular Expression” in VBA Excel and is a sequence of characters that defines the search pattern for finding a specific pattern of characters in a string of values. In a simple word, “we can create a regular expression pattern and use it to search for the string of that pattern.”

Dim regexpObject As Object

Set regexpObject = CreateObject(“VBScript.RegExp”)

.Pattern="\d" Or "[^0-9]"

.IgnoreCase ... Boolean

.Global

.Test

.Replace

.Execute

\d : digit

\D : non-digit

\r : Return { Enter }

[ \t\r\n\f]. That is: \s matches a space, a tab, a carriage return, a line feed, or a form feed.