Regular exception MAC address

[matejrycek]

Hi,

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?

thanks

[matejrycek]

Hi,

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.

[jtkarvo]

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

[matejrycek]

hi,

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

is there another option to do this?

thanks.

[jtkarvo]

You could try this as the regex

\-(\b)

and

$1

as the replacement

[matejrycek]

you are the best bro,

Thank you so much!!