Skip to main content
I am trying to parse out numeric data in this subject line:

 

Eligibility 123456

 

The number I am trying to parse will always be at the end and will follow the word Eligibility.  It will be an unknown number of characters (10-15).  This is how far I am:

 

trim(Right(Subject, 10))

 

Obvious problem... if it isn't exactly ten, it doesn't work.  Help please!
4 risposte
  1. 7 ott 2019, 20:39
    @Jeff Talbot - this is working great, thanks.  My only issue is when the answer is null. Can I update with an IF statement or similar?