How can i make a specific expression

[#1]

Hi,

I have a list of email addresses which display the records. For an example

email Name Size

aa1@aa.com aa1 10

abc@aa.com abc 15

aa2@aa.com aa2 20

abc1@abc.com abc 10

Based on "email" field, How can i make a expression to say 'email' does not contain "aa*@"? So it will return the value "abc@aa.com & abc1@aa.com"

Thanks in adavance.

[#2 · Accepted solution]

Hi dp,

I have not used an expression in the application but instad I have used a macro for the same. Just look whethere it helps you or not. I am pasting a smple application along with this mail.

Thanks joseph.......

[johnw]

Replace the email dimension with this calculated dimension and suppress nulls:

if(not wildmatch(email,'*aa*@*'),email)

[#4]

Thanks Joseph,

I thought about to used a macro for this query.

Thanks,

Dipesh

[#5]

Thanks John,

It works for me.

Much appriciate, Dipesh