Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markus_dreuw
Contributor III
Contributor III

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

Labels (1)
1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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
jonathandienst
Partner - Champion III
Partner - Champion III

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
markus_dreuw
Contributor III
Contributor III
Author

thanks it works