I am trying to run a script to pull information out of the attached spreadsheet and put it into the correct format. Here are the steps I am looking to perform:

1.) Do error-checking for special characters in the column "MAC Addr" before converting
2.) Copy of the information in the column "MAC Addr" over to the "Notes" column
3.) Convert the new "Notes" column field to the the proper MAC Address format - "ab:cd:ef:gh:ij:kl" (all lower case and colon ever 2 characters)
4.) Output the text into the following format:


provision-ap copy-provisioning-params ap-name "«MAC_Addr»"
provision-ap installation default
provision-ap no external-antenna
provision-ap server-name aruba-master
provision-ap ap-group "«AP_Group»"
provision-ap ap-name "«AP_Name»"
provision-ap no syslocation


provision-ap no remote-ap
provision-ap no fqln
provision-ap reprovision ap-name "«MAC_Addr»"


Let me know is this is something anyone can assist me with and I will send over an example of the file.