acantor Posted August 25, 2021 Report Share Posted August 25, 2021 This challenge is arguably more of a mid-week diversion than a real challenge. But I thought others might enjoy this not-too-hard puzzle. I recently updated an email mailing list consisting of about 1000 addresses. The list looked like this... Quote Midge, John <email@example.com> de Ville, Cruella <firstname.lastname@example.org> <email@example.com> firstname.lastname@example.org Didge, Onn <email@example.com> Jack <firstname.lastname@example.org> <email@example.com> firstname.lastname@example.org #Bingo! ... (A total of about 1000) Note that each line appears in one of four formats: Name <email@address> <email@address> email@address not an email address (e.g., #Bingo!) The challenge: use Macro Express to simplify the task of cleaning up the 1000 lines so that each line consists only of an email address: Quote email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org etc. Any line that is not an email address, such as "#Bingo!" or a blank line, should be removed. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.