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 respuestas
@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?