I need to do a find and replace in text fields that contain double quotes ("). I'm field calculating the text fields into fields with a smaller field length because the original fields have a field length of 214 million (LA County Assessors DS04). Unfortunately, when scripting the
arcpy.CalculateField_management(dso4,newField,!newField!.replace(""","'"),'PYTHON')
doesn't work because it reads it as a triple string literal.
I even tried using the \ character to ignore the "
"!Legal_Description_Line1!.replace(\"\"\",\"\'\")"
error returns: EOF while scanning triple-quoted string literal (<string>, line 1)
Is it even possible to field calculate string fields that contain double quotation marks (")?