Joining Emails and extracting domain from email

Cognos 8 Business Intelligence Report Studio
1

I have fields likeemployeename, tomail, tomail1,tomail2 till tomail10.
I want to create a report that will be like finding employees those have sent mail to specific domain.
Like gmail, yahoo etc .
I am stuck on it, please can anyone help me on it.

thnx in advance :slight_smile:

2

search and select prompt

make sure to change the default selection and give the options to search for yahoo gmail etc.

There are enough javascripts to make sure u have the default selection find keyword anywhere in search string.