RegExpression

A

Anna

Hi:
Can any one please tell me the regExpression. I try to do thru instr
but the style of data is not same always. I need the number "894052"
from this string thru regExpr

strSubject="PPV / VOD Research - Dispute - 1st Time - 894052"

NewValue = Mid(strSubject, InStrRev(strSubject, "-") + 2)

Thank You.
 
Top