Recently, I needed to create a one-address-per-line email address list, using only an existing Exchange group mailbox as input.<\/p>\n
First we start in Windows…<\/p>\n
I opened Outlook and prepared to create a new email and typed in the email group.\u00a0 Once shown, I clicked the “plus” (+) symbol next to the group to expand it.\u00a0 Swipe across the list, and do a CTRL+C to copy them to the clipboard.<\/p>\n
Now, to Linux…<\/p>\n
Shell into a Linux box, and paste the clipboard contents into a file (for instance, input.txt).\u00a0 The input format will look a bit like this:<\/p>\n
Jeremy Pavlov <Jeremy.Pavlov@YourLinuxGuy.com>; Other Guy <Other.Guy@YourLinuxGuy.com><\/code><\/pre>\n…and so on…<\/p>\n
Now run the following command against your input file:<\/p>\n
cat input.txt |tr \";\" \"\\n\" |awk '{ print $3 }' | sed s\/\"<\"\/\/g |sed s\/\">\"\/\/g<\/code><\/p>\nAnd you should end up with an output.txt that looks like this:<\/p>\n
Jeremy.Pavlov@YourLinuxGuy.com
\nOther.Guy@YourLinuxGuy.com<\/code>
\n…and so on.<\/p>\nThis format is now perfect for use in various places, like… oh… for instance… the Subscribe2 plugin in WordPress… …Which is exactly where I use it to keep my internal subscriber list up-to-date.<\/p>\n
Enjoy!<\/p>\n
\ud83d\ude42<\/p>\n
<\/p>\n
Update: For a comma-delimited list, use this:<\/p>\n
cat input.txt |tr \";\" \"\\n\"|awk '{ print $3 }'| sed s\/\"<\"\/\/g |sed s\/\">\"\/\/g|tr \"\\n\" \",\"<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"Recently, I needed to create a one-address-per-line email address list, using only an existing Exchange group mailbox as input. First we start in Windows… I opened Outlook and prepared to create a new email and typed in the email group.\u00a0…
Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,109,11,47,110,108],"tags":[],"class_list":["post-903","post","type-post","status-publish","format-standard","hentry","category-aboutthesite","category-awk","category-intermediate","category-linuxgeneral","category-sed","category-wordpress"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pnjn1-ez","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts\/903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=903"}],"version-history":[{"count":8,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts\/903\/revisions"}],"predecessor-version":[{"id":1089,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts\/903\/revisions\/1089"}],"wp:attachment":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}