I am ingesting Windows DHCP logs (via NX-LOG) and Meraki DHCP logs. The Windows DHCP logs by default do not include any colons in the MAC address. The Meraki Logs have colons in the MAC address.
My goal is to have a single field called “DHCP_MACAddress” used to store the extracted MAC address from both logs (and to not have any colons).
How can i remove the colons from the extracted MAC address?
Meraki DHCP Log Line
10.10.10.1 1564510024.512576200 HIAIEFRW01 events dhcp lease of ip 10.10.10.118 from server mac AC:17:C8:F1:G4:22 for client mac DC:8B:28:53:AB:4C from router 10.10.10.1 on subnet 255.255.255.0 with dns 10.1.1.110, 10.1.1.60
Meraki Regular Expression (to match MAC Address)
for\sclient\smac\s(([0-9A-F]{2}[:-]){5}([0-9A-F]{2}))
Result
DC:8B:28:53:AB:4C