Logical operator "not in"

RouterOS Scripting
1

Hello… I’ve been searching about this sintaxe, but did not find anything useful.

Does somebody knows how to get this command to work?

/ppp active print count-only where (address in 203.0.113.0/24 AND address not in 203.0.113.0/27)

Thank you

2 
 /ppp active print count-only where (address in 203.0.113.0/24 AND address in !203.0.113.0/27)
3

Doesn’t work.
Have you tested your code?

Thanks in advance

4

Well it didn’t show an error, but here you go:

/ppp active print count-only where (address in 203.0.113.0/24 and !(address in 203.0.113.0/27))
5

203.0.113.0/27 = {203.0.113.0 - 203.0.113.31}
so range begin 203.0.113.32 to 203.0.113.254

/ppp active print count-only where address~( "203\\.0\\.113\\.(3[2-9]|[4-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-4]))" )

use this link may help you about IP regular expression
http://www.analyticsmarket.com/freetools/ipregex

6

Nice!!!

This worked like a charm
Thank you