I was searing for a simple way to convert all types of mac address to "more" standard format. Found various solution, but not a single line that I did like, so I made one.
This will convert any mac format to XX:XX:XX:XX:XX:XX. (Output can be modified to format of your choice.)
| rex mode=sed field=mac "s/[^0-9a-fA-F]//g s/(..)(..)(..)(..)(..)(..)/\1:\2:\3:\4:\5:\6/g y/abcdef/ABCDEF/"
s/[^0-9a-fA-F]//g remove all that are not 0-9 a-z and A-Z (all symbols are gone)
s/(..)(..)(..)(..)(..)(..)/\1:\2:\3:\4:\5:\6/g set the output format to xx:xx:xx:xx:xx:xx
y/abcdef/ABCDEF/ change to upper case
