I have an invoice which uses the following fee names (with '*' being a wildcard for text before):

 

*FIRST OFFENSE (i.e. 93.1 FIRST OFFENSE, 105.3 FIRST OFFENSE, etc.)

*SECOND OFFENSE

*THIRD OFFENSE

 

What I need to do is pull the fee name when it exists on the invoice.  For example, if the invoice has the fees *FIRST OFFENSE and *SECOND OFFENSE, the report displays the *SECOND OFFENSE fee.  If a THIRD OFFENSE exists on the invoice, then display the *THIRD OFFENSE fee and ignores the FIRST and SECOND.  

 

Any help is greatly appreciated.

 

Thanks