topic Re: If statement wild card in Reporting

If statement wild card

sumitkathpal292 — Sun, 17 Feb 2019 06:23:42 GMT

Hi All,

we need to define internal and external email segregation, we have the field sender and receiver fields . If sender equals *@hello.com and receiver equals *@hello.com than mark as internal all others external.

Currently i did if(sender=="*@hello.com" AND receiver=="*@hello.com.au","internal","external") but unsuccessful .

Any help?

Re: If statement wild card

martin_mueller — Sun, 17 Feb 2019 11:08:42 GMT

eval and where treat * as a literal character, not a wildcard. Use match().

Re: If statement wild card

vnravikumar — Sun, 17 Feb 2019 11:41:36 GMT

HI @sumitkathpal2929

Try this,

| makeresults 
| eval sender ="test@hello.com",receiver="test1@hello.com" 
| eval result = if(match(sender,".*@hello\.com") AND match(receiver,".*@hello\.com"),"internal","external")

Re: If statement wild card

sumitkathpal292 — Sun, 17 Feb 2019 22:04:00 GMT

Thanks, got it

Re: If statement wild card

woodcock — Fri, 08 Mar 2019 03:20:03 GMT

... except in tsats.

Re: If statement wild card

martin_mueller — Fri, 08 Mar 2019 06:30:52 GMT

eval and where commands.