ISE : Import Mac : How to Convert Mac format string to hex format

[mmisonne]

Hello

I must import thousands of mac-address for Ip-Phones.
I scanned those ip-phone-mac from the boxes.

Now all my mac are scanned like a string "aabbccddeeff"

Unafortunaltely , to be imported into ISE they must be on the following format
"aa:bb:cc:dd:ee:ff"

Othewize the ISE send an error like:
"Invalid MAC address. Please enter MAC address as nn:nn:nn:nn:nn:nn"

I am not C+ specialist, so I wonder if it exist a program to do that .
Regards.

Michel Misonne

[Richard Atkin · Accepted solution]

Microsoft Excel can manipulate text strings for you

Sent from Cisco Technical Support iPad App

[mmisonne]

Yes we can do with excel :

Select the column  with all the Mac

Then go to Data > Convert

Select "Fixed lengt"   , Then Next

Type the delimeter , then Finish

You will have now 6 column that you have to rassembled with a formula and interted the caracter ":"

Thanks

Michel Misonne