Qlik Community

Qlik Server Side Extensions Discussions

Discussion Board for collaboration on Server-Side Extensions and Advanced Analytics Integration.

markus_dreuw
New Contributor

Formula to search for specific sign

Good morning

I would like to evaluate a column by controlling if it contains an e-mail addresses respectively an “@”. Before and after the “@” different content can be given, numbers, letters etc. It just has to be controlled if there is an “@” in it.

Is there any formula to do so? Maybe working with an if clause?

Thank you in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: Formula to search for specific sign

I'm not sure where/how you want to use this logic, but

Implicit:

(Index(MailAddress, '@') > 0)

Explicit:

If(Index(MailAddress, '@') > 0, true(), false())

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
MVP
MVP

Re: Formula to search for specific sign

I'm not sure where/how you want to use this logic, but

Implicit:

(Index(MailAddress, '@') > 0)

Explicit:

If(Index(MailAddress, '@') > 0, true(), false())

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

markus_dreuw
New Contributor

Re: Formula to search for specific sign

thanks it works