Filter Email Help

[amit_saini]

Hi Folks ,

I'm having data as per email ID's below:

aaron.simpson@abc.xyz.com

aaron.williams@abc.xyz.com

aaron.zhang@abc.xyz.com

abalazsova@bh.com

abdelmajid.afarsiou@pqr.com

I just want to filter my data based on my email Ids, want to see data only if email id is @abc.xyz.com

Please help!

Thanks,

AS

[renjithpl]

May be this...

LOAD

  Field
FROM
...
Where match(SubField(Field, '@', 2), 'abc.xyz.com')>0;

[sagarkharpude]

use wildmatch in script

if(wildmatch(email,'*@abc.xyz.com*')=1,1,0) as flag

and use this flag in front end

or you can also exclude the records while loading as below

load *

from Tablename where wildmatch(email,'*@abc.xyz.com*')=1;

[#4]

hi,

use in where clause

wildmatch(mailid,'aaron.simpson@abc.xyz.com','aaron.williams@abc.xvz.com')=1;

Regards

Vimlesh

[#5]

Hi,

Please try this:

load

..

from

where wildmatch(upper('abc@xyz.com'),'*@XYZ.COM')=1

Thanks!