topic Re: Check email address in QlikView

Check email address

pmoreno17 — Mon, 02 Jan 2017 13:23:21 GMT

Hola a todos,

Quiero preguntar si alguien tiene alguna fórmula tanto de script o de gráfico en la que sea posible comprobar si una dirección de email es correcta o no.

Muchas gracias y un cordial saludo!

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Hi all,

I want to ask if anyone has any formula of either script or graphic in which it is possible to check if an email address is correct or not.

Thank you very much and best regards!

Re: Check email address

vinieme12 — Mon, 02 Jan 2017 19:32:39 GMT

you can use wildmatch , just specify the email format as you want it

=WildMatch('aefse@gmail.com','*@*.com') << Matches format so will return 1

Or you can do complex checks for each part of the email ID, by breaking the email ID

Example <username> // can contain '.' ,'_','-'

<domainname> // number or '.'s or valid domains such as .com .biz .net

Re: Check email address

vinieme12 — Mon, 02 Jan 2017 20:00:40 GMT

See this thread

Email Address Validation | Qlik Community