Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.