Hi I am a bit stuck, trying to find certain text by query in a text field that varies in length.
It is a horse breeding database, I already have the sire which comes first, I want to get the Dam which is after the hyphen but before the Dam's sire in brackets. Trouble is it is variable.
Example1: Southern Image (USA) - Djel D'Amour (by Dehere (USA))
I want only Djel D'Amour with no leading or trailing spaces.
Example2: lamosa (NZ) - Cinder Bella (NZ) (by Victory Dance (IRE (rest is cut off from source)
I'd like Cinder Bella (NZ) with no leading or trailing spaces.
I've dabbled with Instr, Mid and Len, but can't seem to get it right.
Any help greatly appreciated.
Regards,
David.