My advice: use rindex and substr (I'm sure you can figure out yourself how to do this). or a look-ahead (code already posted by Transient, in the update).

Update: I should have taken a better look at Transient's reply... He posted different solutions, including the rindex/substr one...