Find first space from right

[Purdue2479]

I need an expression which finds the first space from the right and returns the text (variable length) to the right of it.


Ex.

AMINOPH, THEOPHY. INJ

expression should return INJ

 

[pdx_man]

Check out the INSTRREV function, LEN function and RIGHT function.

Total length of string - position of space from right

Take those number of RIGHT characters.