topic Possible Unicode Error?&nbsp; Field Calculator Help!! in Python Questions https://community.esri.com/t5/python-questions/possible-unicode-error-nbsp-field-calculator-help/m-p/34810#M2720 <HTML><HEAD></HEAD><BODY><SPAN>I am getting funny symbols when I do a simple field calculate on a unicode field in a file geodatabase.&nbsp; </SPAN><BR /><BR /><SPAN>I do this:</SPAN><BR /><BR /><SPAN>arcpy.CalculateField_management(outFileThree, "HOTLINK", "!HOTLINK!.lower()", "PYTHON_9.3", "")</SPAN><BR /><BR /><SPAN>and get funny little L or upside down Ls in the field where there were \ characters or \0s.</SPAN><BR /><BR /><SPAN>How do I field calculate correctly field calculate and why is this happening?</SPAN></BODY></HTML> Wed, 05 Mar 2014 12:39:02 GMT MaryM 2014-03-05T12:39:02Z Possible Unicode Error?  Field Calculator Help!! https://community.esri.com/t5/python-questions/possible-unicode-error-nbsp-field-calculator-help/m-p/34810#M2720 <HTML><HEAD></HEAD><BODY><SPAN>I am getting funny symbols when I do a simple field calculate on a unicode field in a file geodatabase.&nbsp; </SPAN><BR /><BR /><SPAN>I do this:</SPAN><BR /><BR /><SPAN>arcpy.CalculateField_management(outFileThree, "HOTLINK", "!HOTLINK!.lower()", "PYTHON_9.3", "")</SPAN><BR /><BR /><SPAN>and get funny little L or upside down Ls in the field where there were \ characters or \0s.</SPAN><BR /><BR /><SPAN>How do I field calculate correctly field calculate and why is this happening?</SPAN></BODY></HTML> Wed, 05 Mar 2014 12:39:02 GMT https://community.esri.com/t5/python-questions/possible-unicode-error-nbsp-field-calculator-help/m-p/34810#M2720 MaryM 2014-03-05T12:39:02Z Re: Possible Unicode Error? Field Calculator Help!! https://community.esri.com/t5/python-questions/possible-unicode-error-nbsp-field-calculator-help/m-p/34811#M2721 <HTML><HEAD></HEAD><BODY><SPAN>I think it's not working because python sees / as an escape character. It turns /0 into a special character (that's show up odd in your attribute table). I couldn't find an easy and functional solution. </SPAN><BR /><BR /><SPAN>As much as I hate to say so, the easiest fix might be to just use vb script instead of python:</SPAN><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">arcpy.CalculateField_management(outFileThree, "HOTLINK", "LCase( [HOTLINK] )", "VB", "")</PRE><BR /><BR /><SPAN>Let me know how it goes!</SPAN></BODY></HTML> Wed, 05 Mar 2014 14:06:43 GMT https://community.esri.com/t5/python-questions/possible-unicode-error-nbsp-field-calculator-help/m-p/34811#M2721 JoshuaChisholm 2014-03-05T14:06:43Z Re: Possible Unicode Error? Field Calculator Help!! https://community.esri.com/t5/python-questions/possible-unicode-error-nbsp-field-calculator-help/m-p/34812#M2722 <HTML><HEAD></HEAD><BODY><SPAN>After several days of trying and finally posting and then I just figured it out...</SPAN><BR /><BR /><SPAN> arcpy.CalculateField_management(lyr, "TestHotlink","r!HOTLINK!.lower()", "PYTHON_9.3", "")</SPAN><BR /><BR /><SPAN>I kept trying things like r(!HOTLINK!) which did not work.</SPAN></BODY></HTML> Wed, 05 Mar 2014 14:14:02 GMT https://community.esri.com/t5/python-questions/possible-unicode-error-nbsp-field-calculator-help/m-p/34812#M2722 MaryM 2014-03-05T14:14:02Z