Partial String Match for Table Lookup input

Hello,

I’m having a problem with a lab results interface where I need to match micro-organism names and translate to a coded value.

I’ve built a lookup table to account for the micro-organism names and corresponding output codes.

My problem is that the OBX5 result text doesn’t pass the exact micro-organism name as the OBX5 value; the micro-organism name can  be embedded with the OBX5 text

*******************************************

Example:    Input Table:  BACILLUS ANTHRACIS

                 Output Table:  BACANT

Trnx #1:

OBX5:  |2+ BACILLUS ANTHRACIS|

Trnx #2:

OBX5 |PRESUMPTIVE BACILLUS ANTHRACIS|

Trnx #3:

OBX5  |>100,000 C/F BACILLUS ANTHRACIS|

*****************************************

In all these examples the output should be BACANT.

I’m having difficulty in matching the substring against the table.

NOTE: we also have multiple tables for translations of different organisms to account for a significant exception rules.

Thanks

Bill