Regular Expression Patterns

Some fields in PropReports allow you to use regular expressions to match multiple Account Ids.  Regular expressions are a concise and flexible means to specify patterns of text.  Below are some examples:

ExpressionFunction
ABC.* All accounts that start with ABC
(?!^ABC).*All accounts that do not start with ABC
(?!^ABC)(?!^XYZ).*All accounts that do not start with ABC or XYZ
^[0-9]+$All numeric (e.g. 123456) accounts
.*CAD$All accounts ending in CAD
^ABC[0-9][0-9][0-9]$All accounts starting with ABC followed by three digits

For example, if you would like to export execution data for all accounts that have a numeric Account Id using PropReports' Post-Process functionality, you would enter ^[0-9]+$ in the Account Id field:

Related Topics / How To

More detailed information on regular expressions can be found in the PHP Language Manual.