📖 2 mins read

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 test@nsb.com but not true@generalaudittool.com

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


GAT+: Regular Expressions You Would Use 1

This is a great site for testing regular expressions.

Thanks for sharing and spreading the word!