A regular expression, often called a pattern, is an expression that describes a set of strings. They are usually used to give a concise description of a set, without having to list all elements.
The regular expression language is designed and optimized to manipulate text. The language comprises two basic character types: literal text characters and metacharacters.
Visual Studio Editor Regular Expression
^:b* match leading white space
Example: Scanning for HREFs
Sub DumpHrefs(inputString As String) Dim r As Regex Dim m As Match r = New Regex("href\s*=\s*(?:""(?<1>[^""]*)""|(?<1>\S+))", _ RegexOptions.IgnoreCase Or RegexOptions.Compiled) m = r.Match(inputString) While m.Success Console.WriteLine("Found href " & m.Groups(1).Value _ & " at " & m.Groups(1).Index.ToString()) m = m.NextMatch() End While End Sub
Example: Changing Date Formats
Function MDYToDMY(input As String) As String Return Regex.Replace(input, _ "\b(?\d{1,2})/(? \d{1,2})/(? \d{2,4})\b", _ "${day}-${month}-${year}") End Function
Find SQL script comment
\/\**:bObject([^\>]*)\**\/