topic Re: Valid email address count in QlikView

Valid email address count

Sat, 12 Jan 2013 08:26:57 GMT

Dear,

I need to count valid email address from given below list:

email_address

michael.marchetti@comnos.com

tim.steinlein@comnos.com

michael.marchetti@comnos.de

tim.steinlein@comnos.de

michael.marchetti@unvalid@comnos.de

zain.com

null

zain@hotmail.com

Count result is 5 and also show records in chart object.

Regards,

Zain.

Re: Valid email address count

Gysbert_Wassenaar — Sat, 12 Jan 2013 09:53:29 GMT

Another quick-and-dirty (e.g. no check for valid domain extensions):

=sum(if(SubStringCount(email_address,'@')=1,

if(SubStringCount(subfield(email_address,'@',-1),'.') >0,1,0)))

If you want it really correct then first read this. That's what you'll have to implement. If you want to do that kind of validation I recommend you buy a data cleansing tool that's specifically designed for that purpose.

Re: Valid email address count

Sat, 12 Jan 2013 13:51:36 GMT

Thank again for your reply, I am doing visualizations of data to soft-check data quality, this is user requriment and i am try to fill. They are using Qlikview 11 and want to manage some data quality in it, i know very well format validation in data is difficult and some not possible.

Regards,

Zain.