Display Text after a Particular Character in Field 1

[kime1974]

I am using Crystal 8.5 and XI.

I would like to display a field in my report that displays the text after the "-" in the field. Here are some examples:

Field Data Formula should display
JYMC-M$1 M$1
C100MC-M$1P M$1P
BC3T5RDR-R$3/5M$1+ R$3/5M$1+

Any help with this?
Thanks!
Kim

 

[AndyMc]

Try:

If Instr({table.field},"-") > 0 then
mid({table.field},Instr({table.field},"-")+1)
else
{table.field}

 

[kime1974]

Perfect! Thanks!