find char in string

[#1]

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

[Anonymous · Accepted solution]

Try something like :

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

[#3]

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