cam58953

Calculate Field with Quotation marks "

Discussion created by cam58953 on Oct 29, 2012
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 (")?

Outcomes