Regular exception MAC address

(Matej Rycek) #1


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?


(Matej Rycek) #2


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.

(Matej Rycek) #4


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

(Matej Rycek) #6

you are the best bro,

Thank you so much!!

(system) closed #7

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