GAT has some very powerful filtering right at your fingertips, but you can boost this by an order of magnitude by adding regular expressions to the metadata search criteria.
As one of our customers wisely said if you have a problem that involves having to use a regular expression, then you have two problems….
But good news, we hope to make it a little simpler for you, so here are some regular expressions you might find useful for day to day searching in GAT.
Note: Example Domain name = generalaudittool.com.
The ‘Regex options can be found in a variety of different search locations:
Matches (partial string or reg.ex) and doesn’t match (partial string or reg.ex.)
All addresses from your domain
All addresses not from your domain
All addresses not from your domain or from generalauditool-corp.com or generalauditoolinc.com, etc.
Any numbered account on your domain (deleted accounts pick up numbers for a period, these numbers are between 10 and 20 digits, but are typically 11).
Any numbered account (with between 10 and 20 digits) from any domain
should also work but has a looser domain definition.
Any email address that begins with Te or te at any domain.
Will catch Test@generalaudittool.com or email@example.com but not firstname.lastname@example.org
Any email address that begins with Rob or rob at the domain generalaudittool.com
Any email address that contains Ti or ti at the domain generalaudittool.com
Will catch Nastia@generalaudittool.com but not Arthur@generalaudittool.com
Any variable containing a string of the type X or x, followed by 00, followed by 6 or 7, followed by any 4 digits
Will catch ‘A man called bond X0071234 in a house.’
Any variable with no number in it will be caught by
If student accounts all have numbers or are part numerical and staff accounts do not, this will return all staff accounts.
To search for null or blank fields use the regular expression
This will return rows where there is no value in the column you are searching under.
To find two files at once with two different names