I think we will take it from choroba approach mine was quite different I started from here by snatching out the hex and got stuck there:

perl -pe 's/([[:xdigit:]]{1,2}:){23}[[:xdigit:]]{1,2}/$HEX/g;' testing
+.csv
[download]