topic Expression for handling two kinds of invalid email adresses in DI Studio in SAS Data Management

Expression for handling two kinds of invalid email adresses in DI Studio

EinarRoed — Tue, 27 Nov 2012 10:01:22 GMT

I've set up a simplified DI Studio job for a problem. It has a source data set that contains invalid email adresses (SS_EMAIL), and an Extract transformation that I'd like to use to correct them. There's two kinds of invalid email adresses:

1) user@.domain.com, which should become user@domain.com

2) user@ domain.com, which should become user@domain.com

What kind of expression can I use to make these two corrections? They'll be fixed in the source data eventually, but that might take weeks so my job must be able to handle them for the time being.

Thanks for your time.

Re: Expression for handling two kinds of invalid email adresses in DI Studio

LinusH — Tue, 27 Nov 2012 11:24:32 GMT

The exact syntax you will have to write by yourself.

But it could involve finding the position right after the @-sign, and test if this position is not a special char (see NOTALNUM Function and others).

Re: Expression for handling two kinds of invalid email adresses in DI Studio

art297 — Tue, 27 Nov 2012 14:32:19 GMT

Can you use tranwrd? e.g.:

data have;

informat email $50.;

input email &;

email=tranwrd(tranwrd(email,"@.","@"),"@ ","@");

cards;

user@.domain.com

user@ domain.com

;

Re: Expression for handling two kinds of invalid email adresses in DI Studio

FredrikE — Tue, 27 Nov 2012 14:37:47 GMT

how about using my favorite function tranwrd?:

data email;

length emailin emailout $200;

emailin = 'user@.domain.com';

emailout = tranwrd(tranwrd(emailin,'@ ','@'),'@.','@');

output;

emailin = 'user@ domain.com';

emailout = tranwrd(tranwrd(emailin,'@ ','@'),'@.','@');

output;

run;

Regards Fredrik