Regular exception MAC address


(Matej Rycek) #1

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


(Matej Rycek) #2

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.


#3

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


(Matej Rycek) #4

hi,

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

is there another option to do this?

thanks.


#5

You could try this as the regex

\-(\b)

and

$1

as the replacement


(Matej Rycek) #6

you are the best bro,

Thank you so much!!


(system) #7

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