Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
I'm having data as per email ID's below:
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
May be this...
LOAD
Field
FROM
...
Where match(SubField(Field, '@', 2), 'abc.xyz.com')>0;
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;
hi,
use in where clause
wildmatch(mailid,'aaron.simpson@abc.xyz.com','aaron.williams@abc.xvz.com')=1;
Regards
Vimlesh