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

    Extracting text in a line

    matthew@thermalvisionresearch.co.uk

      Hi

       

      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.