SAS EG to Clean Email Addresses

Fri, 14 Oct 2016 07:56:44 GMT

Hi All,

Forgive me as I am a new SAS EG user (version 7.1); I have been assigned a data scrubbing task and it's been requested that I use SAS EG in order to do so.

I've been moving forward fairly well; however, I've encountered a problem that I cannot seem to intuitively resolve. I have several data sets which all have email addresses. Some of my email addresses contain junk characters which I have used the compress function to remove.

Unfortunately, I also have email addresses where I'd like to remove some characters based on where in the email address they are positioned.

Here are 2 examples:

Email Address: ..johndoe@gmail.com

Email Address: johndoe@gmail.com..

Obviously you can see what I need to do.

I'd like to use an advanced expression to

1. Remove all non-alphabetic characters before the first alphabetic character in the email string

2. Remove all characters after ".com"

Thoughts?

Thanks in advance,

Tessa

Featured content from SAS Support Communities

SAS EG to Clean Email Addresses