0 Replies Latest reply on Sep 24, 2013 12:47 PM by dmorgan

    Parse out email addresses

    dmorgan

      Title

      Parse out email addresses

      Post

           Hello,

           I'm trying to add in mailit 5 to a hosted fmp12 db , the plug in works well in testing and I want to be able to parse out the to from and cc addresses from the simple receiving solution. If you're not familiar with it stores to emails as comma seperated and all in one field per message the same for cc and from but with only one sender.

           {EXAMPLE <EXAMPLE@example.com>, "'joe.blow@gmail.com'" <joe.blow@gmail.com>, "Last, First" <name@email.com>}

           I'm able to parse data in the "from" field as a text calc 

           Middle(Messages::From; Position(Messages::From; "<"; 1; 1)+1; Position(Messages::From; ">";1; 1) - Position(Messages::From; "<";1; 1)-1  )

           Which takes  "Last, First" <name@email.com> and gives name@email.com

           I need it to do the same for the "to" and "cc" which can have multiple emails in it, as a list would probably be easiest to work with.

           Don't know if it matters but it may have to run on server as well.