/
Regular Expression Patterns
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.
, multiple selections available,
Related content
Exclusion & Inclusion rules for Accounts and Adjustments on Uploads
Exclusion & Inclusion rules for Accounts and Adjustments on Uploads
Read with this
Assuring Trade Fee Plans are Assigned to All Accounts
Assuring Trade Fee Plans are Assigned to All Accounts
Read with this
Assign a Trade Fee Schedule
Assign a Trade Fee Schedule
Read with this
Per Symbol
Per Symbol
Read with this
Fee Schedule Formulas
Fee Schedule Formulas
Read with this
Fee Rules
Fee Rules
Read with this