A simple question in regular expression

Question

I need to find a bunch of files for everything that contains "tblPayment" or "tblInvoice"

I also want to match any tables with the name "tblPaymentMethod", "tblInvoiceItem", "tblInvoicePayment"

Anyone want to help me write a regex for this?

Thanks again!

Answer 1

tbl(Invoice|Payment)+

it will also match tables without a table prefix if you need this flexibility.

: (.. tblInvoice|tblPayment|...), RegEx , , . , , - , .

Answer 2

.

tblPayment|tblInvoice|tblPaymentMethod|tblInvoiceItem|tblInvoicePayment

, .

Answer 3

tbl(Payment(Method)?|Invoice(Item|Payment)?)

, , , , .

Answer 4

Perl RE:

/tbl
 ((Payment(Method)?)
 |
 (Invoice(Item|Payment)?))
/x

, .

Answer 5

python - :    "TBL (- | )? +"

Answer 6

If you want to match any table name that starts with tblInvoice or tblPayment, then this will do:

tbl(?:Invoice|Payment)\w*

(?: Invoice | Payment) is a non-capture group (more effective in this case than a capture group). And then \ w * will not necessarily match the alphanumeric characters following it.