Having not used Filemaker for some considerable time I'm trying to get my head round this little problem.
I have an email database that imports mail from Apple Mail when doing this it creates the sender address as
"Reed, Charlie" <Charlie.Reed@flir.uk.com>
Andrea Murray <Andrea.Murray@manchester.ac.uk>
"Davies, Anne [anned]" <Anne.Davies@liverpool.ac.uk>
I really just need the email address only so always the bit between the < and > I've tried left and right and trim but I'm just abit rusty.
Hoping somebody can help.