I am having an issue replacing an ! as a character from my record. I want to replace a ! as a [blank]. I tried using this statement, but it does not work:
arcpy.CalculateField_management(CISAddressSDEFL, "NEIGHBOUR", "!NEIGHBOUR!.replace(\"!\", \"\")", "PYTHON", "")
All other special characters work, but not the !. Any ideas on how to perform a replace?