feature merger and join using wildcard

HI All,

 

 

I never really thought about this one until now, but is it possible to featuremerge on wildcard values?

 

 

For example,

 

 

I have a point file with an ID value.  The ID values are unique.  ie A, B, C, D

 

I have a many table of values with a ID value of A_1990, A2, A, B1,B2,BC,D1,D3,D9

 

 

Is it possible feature merge based on a wild card?

 

ie..  *A* join to A_1990,A2

 

        *B* joins to B1,B2,BC

 

       *D* joins to D1,D3,D9