Live Forums/ Traffic LIVE/Support!
Regular Expressions (RegEx) Cheatsheet
Louis Almeida
posted this on October 03, 2011 14:45
Traffic LIVE v3 saw the inclusion of Regular Expressions (RegEx) in certain areas of the system including Task & Job progress.
These provide a concise and flexible means for "matching" (specifying and recognizing) strings of text, such as particular characters, words, or patterns of characters.
More info about how regular expressions work can be found at http://www.regular-expressions.info
In the meantime below is a cheatsheet to help you get started.
[abc] |
A single character: a, b or c |
[^abc] |
Any single character but a, b, or c |
[a-z] |
Any single character in the range a-z |
[a-zA-Z] |
Any single character in the range a-z or A-Z |
^ |
Start of line |
$ |
End of line |
\A |
Start of string |
\z |
End of string |
. |
Any single character |
\s |
Any whitespace character |
\S |
Any non-whitespace character |
\d |
Any digit |
\D |
Any non-digit |
\w |
Any word character (letter, number, underscore) |
\W |
Any non-word character |
\b |
Any word boundary character |
(...) |
Capture everything enclosed |
(a|b) |
a or b |
a? |
Zero or one of a |
a* |
Zero or more of a |
a+ |
One or more of a |
a{3} |
Exactly 3 of a |
a{3,} |
3 or more of a |
a{3,6} |
Between 3 and 6 of a |
Below are a couple of online tools to help build/test your expressions:
Some useful examples to test timesheets & quotes:
\bm(\w* )(\w* )- task
Match any Task Description beginning with "m", then containing 2 words with space at the end, followed by "- Task".
e.g. "Mihai Chira - Task", "Matt Auld - Task",
\b[2][0-9]*
Matches any number beginning with 2: (23,24,245,23567)
2[0-9]\b
Matches number in 20's
^[0-9]\b
Match a single digit id. e.g. 1,2,3,4,5
\b[0-9]?[0-9]\b
Match 1-100 (id's)
day: [0-9]
Match entry with "Day: [digit]" in it's comments
\bj[0-9]?[0-9]\b
Match job numbers J0 - J100
^m(\w*)\b
Client name with 1 word beginning with "m"
^m(\w* )(\w*)
Client name with 2 words beginning with "m" e.g. would match "Marketing Store" but not "McDonalds" (one word)
Match id beginning with 3,4,5 or 7
^3|^4|^5|^7
Comments latest first
I really have no idea what any of this means to us in terms of using Traffic Live. Anyone care to clue me in?
Fantastic cheat sheet - it's changed my life, well my working life at least!