2 Replies Latest reply on Oct 12, 2015 3:37 AM by matthew@thermalvisionresearch.co.uk

    Extracting text in a line




      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.