Link to home
Start Free TrialLog in
Avatar of rgagli1
rgagli1

asked on

Trying to parse out the SMTP email addresses from an exchange export

Hi.  I received a document that lists all the users information along with a field called Secondary email address.  This field is only the extract of the email addresses field and looks horrible.  Is there a way I can quickly extract this data with the email addresses only?

Here is an example:


smtp:brad.smith@radio.com;X400:c=US;a= ;p=XXX;o=USA;s=Smith;g=Brad;;smtp:Brad.Smith@tunes123.com;SMTP:BSmith@fan.com

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of dathho
dathho

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rgagli1
rgagli1

ASKER

I would assume this is Exchange Server 2003.  I have exchange 2003 on my desktop.  The IT group said this is all they will give me.  Is there any way to clean this up?