Regular Expressions
Description
How to define patterns to select specific elements in an email, file, attachment or document.
Location
Regular expressions can be defined in different locations throughout in the application:
Definition
A regular expression (sometimes abbreviated to "regex") is a way for a computer user or programmer to express how a computer program should look for a specified pattern in text and then what the program is to do when each pattern match is found.
Components
Below is a list of the most commonly used elements in creating a regular expression:
Character |
Description |
\ |
Marks the next character as either a special character or escapes a literal. For example, "n" matches the character "n". "\n" matches a newline character. The sequence "\\" matches "\" and "\(" matches "(". |
^ |
Matches the position before the first character in the string. |
$ |
Matches the position after the last character in the string. |
* |
Matches the preceding character zero or more times. For example, "zo*" matches either "z" or "zoo". |
+ |
Matches the preceding character one or more times. For example, "zo+" matches "zoo" but not "z". |
? |
Matches the preceding character zero or one time. For example, "a?ve?" matches the "ve" in "never". |
. |
Matches any single character except a newline character. |
(pattern) |
Matches pattern and remembers the match. The matched substring can be retrieved from the resulting Matches collection, using Item [0]...[n]. To match parentheses characters ( ), use "\(" or "\)". |
x|y |
Matches either x or y. For example, "z|wood" matches "z" or "wood". "(z|w)oo" matches "zoo" or "woo". |
{n} |
n is a non-negative integer. Matches exactly n times. For example, "o{2}" does not match the "o" in "Bob," but matches the first two o's in "foooood". |
{n,} |
n is a non-negative integer. Matches at least n times. For example, "o{2,}" does not match the "o" in "Bob" and matches all the o's in "foooood.". "o{1,}" is equivalent to "o+" and "o{0,}" is equivalent to "o*". |
{n,m} |
m and n are non-negative integers. Matches at least n and at most m times. For example, "o{1,3}" matches the first three o's in "fooooood.". "o{0,1}" is equivalent to "o?". |
[xyz] |
A character set. Matches any one of the enclosed characters. For example, "[abc]" matches the "a" in "plain". |
[^xyz] |
A negative character set. Matches any character not enclosed. For example, "[^abc]" matches the "p" in "plain". |
[a-z] |
A range of characters. Matches any character in the specified range. For example, "[a-z]" matches any lowercase alphabetic character in the range "a" through "z". |
[^m-z] |
A negative range characters. Matches any character not in the specified range. For example, "[m-z]" matches any character not in the range "m" through "z". |
Command |
Description |
\b |
Matches a word boundary, that is, the position between a word and a space. For example, "er\b" matches the "er" in "never" but not the "er" in "verb". |
\B |
Matches a non-word boundary. "ea*r\B" matches the "ear" in "never early". |
\d |
Matches a digit character. Equivalent to [0-9]. |
\D |
Matches a non-digit character. Equivalent to [^0-9]. |
\f |
Matches a form-feed character. |
\n |
Matches a newline character. |
\r |
Matches a carriage return character. |
\s |
Matches any white space including space, tab, form-feed, etc. Equivalent to "[ \f\n\r\t\v]". |
\S |
Matches any nonwhite space character. Equivalent to "[^ \f\n\r\t\v]". |
\t |
Matches a tab character. |
\w |
Matches any word character including underscore. Equivalent to "[A-Za-z0-9_]". |
\W |
Matches any non-word character. Equivalent to "[^A-Za-z0-9_]". |
Please check the links below for a more extensive list of commands that can be used in a regular expression.
Examples
(BE){0,1}[0]{0,1}[0-9]{9}
\b\w{6}\b
(\d{1,3}\.){3}\d{1,3}
((2[0-4]\d|25[0-5]|[01]?\d\d?)\.){3}(2[0-4]\d|25[0-5]|[01]?\d\d?)
a.*b finds the longest string starting with a and ending with b: aaabaab returns aaabaab
a.*?b finds the shortest string starting with a and ending with b: aaabaab returns aaab
More information on Regular Expressions
Wikipedia page explaining origin and use of regular expressions
https://en.wikipedia.org/wiki/Regular_expression
Microsoft MSDN page explaining the regular expression language
https://msdn.microsoft.com/en-us/library/az24scfc(v=vs.110).aspx