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:
| Expression | Function |
|---|---|
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.