topic Python - How to do a character replace when an ! is involved in Python Questions https://community.esri.com/t5/python-questions/python-how-to-do-a-character-replace-when-an-is/m-p/668673#M51887 <HTML><HEAD></HEAD><BODY><P>I am having an issue replacing an ! as a character from my record.&nbsp; I want to replace a ! as a [blank].&nbsp; I tried using this statement, but it does not work:</P><P></P><P>arcpy.CalculateField_management(CISAddressSDEFL, "NEIGHBOUR", "!NEIGHBOUR!.replace(\"!\", \"\")", "PYTHON", "")</P><P></P><P>All other special characters work, but not the !.&nbsp; Any ideas on how to perform a replace?</P></BODY></HTML> Mon, 03 Apr 2017 21:15:40 GMT IanPeebles 2017-04-03T21:15:40Z Python - How to do a character replace when an ! is involved https://community.esri.com/t5/python-questions/python-how-to-do-a-character-replace-when-an-is/m-p/668673#M51887 <HTML><HEAD></HEAD><BODY><P>I am having an issue replacing an ! as a character from my record.&nbsp; I want to replace a ! as a [blank].&nbsp; I tried using this statement, but it does not work:</P><P></P><P>arcpy.CalculateField_management(CISAddressSDEFL, "NEIGHBOUR", "!NEIGHBOUR!.replace(\"!\", \"\")", "PYTHON", "")</P><P></P><P>All other special characters work, but not the !.&nbsp; Any ideas on how to perform a replace?</P></BODY></HTML> Mon, 03 Apr 2017 21:15:40 GMT https://community.esri.com/t5/python-questions/python-how-to-do-a-character-replace-when-an-is/m-p/668673#M51887 IanPeebles 2017-04-03T21:15:40Z Re: Python - How to do a character replace when an ! is involved https://community.esri.com/t5/python-questions/python-how-to-do-a-character-replace-when-an-is/m-p/668674#M51888 <HTML><HEAD></HEAD><BODY><P>I figured it out, I basically concerted the ! to an ASCI code and it worked.&nbsp; Here is my syntax:</P><P></P><P># ! Screening<BR />arcpy.SelectLayerByAttribute_management(CISAddressSDEFL, "NEW_SELECTION", "NEIGHBOUR LIKE '%!%'")<BR />explanationPointChar = chr(33)<BR />arcpy.CalculateField_management(CISAddressSDEFL, "NEIGHBOUR", "!NEIGHBOUR!.replace(explanationPointChar, \"\")", "PYTHON", "")</P></BODY></HTML> Mon, 03 Apr 2017 21:51:59 GMT https://community.esri.com/t5/python-questions/python-how-to-do-a-character-replace-when-an-is/m-p/668674#M51888 IanPeebles 2017-04-03T21:51:59Z