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: 
Not applicable

find char in string

Hi

I want to make sure that the value I have in a column is an e-mail (the column type is string ).

in order to do that , I want to put a condition on this column , by looking if the string contains that char : @

does someone know how can I do that ?

thanks

Moni

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try something like :

     if ( Index ( [YourEmailField] , '@' ) > 0 , 'Good' , 'Bad' )

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Try something like :

     if ( Index ( [YourEmailField] , '@' ) > 0 , 'Good' , 'Bad' )

Not applicable
Author

thanks Bill,

but I want to put it in a chart object as a condition , and it is still does not work

marcus_sommer

I think this is also helpful: Re: Check validity of a phone number

- Marcus