Valid email address count

[#1]

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.

[Gysbert_Wassenaar · Accepted solution]

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.

[#3]

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.