topic Re: find char in string in QlikView

find char in string

Sun, 25 Oct 2015 09:18:54 GMT

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

Anonymous — Sun, 25 Oct 2015 10:13:44 GMT

Try something like :

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

Sun, 25 Oct 2015 10:25:52 GMT

thanks Bill,

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

marcus_sommer — Sun, 25 Oct 2015 11:00:33 GMT

- Marcus