Wondering if there is an easy way to use FM to search for emails in a block of text and add them to a table?
I have a database that I use to track transactions. Colleagues send me a list of emails in paragraph (text) form and I then need to go search for them and paste into a table.
Is there a script way to search a block of text (probably paste in to field) and then output just the emails?
Filter the text field on email-acceptable chars plus space, "@" and ¶;
Substitute ". " and ".¶" with ¶
Substitute space with ¶
Walk the resulting list, if patterncount(currentListElement; "@") add the currentListElement to a $EmailsList