Regular exception MAC address


i would need parse this MAC address 00-24-D7-75-AF-6C to this string 0024D775AF6C, because i need to search by MAC address, which give me the DHCP log and in dhcp is this without the “-”.

I tried possible ways with regular exception like this (([0-9A-Fa-f][^-]*)), but none works

does anyone know how to do it?



please is there any options, how to parse MAC address (00-24-D7-75-AF-6C) without the this character"-"?
i know there is the option to separate by “-”, but if i use this option i must create 6 new fields and I do not want this.
i tried “replace with regular exception”, but without any progress.
could you give me an advice please,how could that be done?

I do not know what to set up in field “replacement”

Thanks for help.

just leave the replacement field empty. And regex wuold be -
And check replace all occurrences of the pattern.


i can not leave the field “replacement” empty :(.

is there another option to do this?


You could try this as the regex




as the replacement

you are the best bro,

Thank you so much!!

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.