data validation using wildcards??

[davidmuel]

I have a need to cross reference and validate a listing of GL account codes
(12 numeric digits) with an "account filter" table that is formatted with
wild cards and bring back one of the fields in the account filter table. The
original data table can be '000s of rows so I would like to find a way to
automate this as much as possible.

Here some sample data:
Raw data table:

ACCT
731013000804
731510000901
731511000301
731511000340
731511000806
731513000801

For each of these account codes (and thousands more), I would like to cross
reference against an account filter table to determine status of account and
if code "optional" or "required".

Sample of Account Filter table where "_" underscores indicate wild card
characters (note, I could easily use another character for the wildcards, the
underscore is what comes out of our accounting system).

ACCOUNT FILTER STATUS
7310_____8__ OPTIONAL
7315_____8__ REQUIRED
7315100009__ OPTIONAL
731511000340 REQUIRED

If there is no match in the listing, then I would like to keep my status
blank.

I hope this is enough information for someone to point me in the right
direction. Thanks in advance for your help.
David