vba - Regex to insert new line character after semicolon and remove names before email -
i have list of emails on 1 line clean up. in following format:
jones, peter <jones.h7@petstore.com>; bradley, charles <bradley19@petstore.com>; frank, hilda <frank.hl@petstore.com>;
and desired result follows:
jones.h7@petstore.com; bradley19@petstore.com; frank.hl@petstore.com;
so names , angle brackets around email removed.
i regex solution. have tried replacing ;\s
\r\n
did not tthe expected result. new regex i'm stuck.
instead of replacing <...>
-ed emails, can match mails 1 of following regular expressions (if insist on regex solution):
<([^@<>]+@[^@<>]+)>;
the email addresses in captured group 1. see demo
if need string replacing not need, may still use
<([^@<>]+@[^@<>]+)>(;)|[^<>]+|<|>
with $1$2
replacement string. see demo
Comments
Post a Comment