Pattern Matching ..Waterfall Logic ... Table Logic?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings!

I'd like to know if "pattern matching" is possible in MS Access?
What's pattern matching?
Table_Rules
FieldA(3) FieldB(3) Product_Desription
..1. .1. = product A
..12 ... = product B
121 ... = product C
..1. 1.. = product D
..11 .C. = product E
F11 D1. = product F

...so you've got a transaction table with records containing FieldA and FieldB,
and you want to find out what the associated Product_Description is .. But,
the rules have to be evaluated in order, so the "less stringent" rules will
kick out
a success early, while the records with the more stringent criteria will
score a
success once they reach the bottom of the rules table.

Links, direction, other help boards appreciated!

Cheers!
 
...or I might have had it backwards..the more stringent rules
are at the top, and the more general rules are at the bottom..
hopefully you get the idea anyway..
 
...regular expressions..didn't know if there was a simpler way... I see
VB.NET has an assembly dedicated too..
 
Back
Top