How to Like function?

[Anonymous]

Hi,

I have a field with emails, the idea is to have the sum of views that the users are making to some documents.

But I will like to exclude the emails that are like '@gmail.com' for example.

Actually I am summing everything but will like to sum all except for the gmail accounts.

How can I do that?

[vishsaggi]

May be like Not WildMatch() function. Can you explain a little more if below is not what you are expecting?

IF(Not WildMatch(YourfieldName, '*@*'), 1, 0) As yourNewField

[krishnacbe]

May be like this

=if(SubStringCount(Email,'gmail')=1,0,Count(ID))

[Anonymous]

I need to use it in an expression, how can I put it there?

[vishsaggi]

May be this?

= Sum(IF(Not WildMatch(YourfieldName, '*@*'), 1, 0))

[effinty2112 · Accepted solution]

Hi Roberto,

Maybe something like:

Count({$<email -={'*gmail.com'}>}ViewID)

You will need to change email and ViewID to the fieldnames you are actually using.

Regards

Andrew

[Kushal_Chawda]

Create the flag in script

LOAD *,

           if(wildmatch(lower(Email),'*@gmail.com*',1,0) as EmailFlag

FROM Table;

Now you can write the expression in chart like below

=count({<EmailFlag={0}>} ID)

[Anonymous]

This is what I needed, thank you

[effinty2112]

Hi Roberto,

Glad to help!!