I can work with simply taking the last three digits of the MAC address and conveting that into a binary number.

I'm currently struggling with the following:

$Z=VAL("&"+substr(@address, 10, 3))

The value always yields a 0. I've tried a variety of start and stop numbers within the SUBSTR function, to no avail.

Any ideas?