nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using " instead of inches in a field

JimNoble

Hi guys, I am trying to calculate a field to read 2" HDPE in every row

#Calculate field Conduit feature class Underground
arcpy.CalculateField_management("Underground.dbf", "Conduit",
                                '"2in HDPE"', "PYTHON3")

With this I can get every row to read 2in HDPE but everytime I try to insert " instead of in I get an error. Could you guys help me please!

Thanks!

-Jim Noble

Find more posts tagged with

Accepted answers

All comments

GeoJosh

Jim,

Try this:

arcpy.CalculateField_management("Underground.dbf", "Conduit",
                                '"2\" HDPE"', "PYTHON3")‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

You need a forward back slash (\) before the parentheses ("). Otherwise, the Python interpreter will think you are trying to close the string.

Best,

Josh

JoshuaBixby

Forward slash? I think "\" is commonly called backslash.

Even with escaping the double quotes, the string still needs to be single quoted and not double quoted.

<SPAN class="string token">"'2\" HDPE'"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

JoeBorgione

Just got back from an ESRI user seminar: at pro 2.5 there finally is Find and Replace functionality!

Personally, I shy away from any special characters in database field values; notice how you need to escape them to get them in there. 'nuff said.....

DanPatterson_Retired

not quite the same... but "unicode" is quite a large world to fully explore.

dq <SPAN class="operator token">=</SPAN> u<SPAN class="string token">"\u201D"</SPAN>

f<SPAN class="string token">"quoting{dq}"</SPAN>

<SPAN class="string token">'quoting”'</SPAN>

<SPAN class="string token">"quoting{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>dq<SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">'quoting”'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoeBorgione

s <SPAN class="operator token">=</SPAN> <SPAN class="string token">'12in pipe'</SPAN>
s <SPAN class="operator token">=</SPAN> s<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'in'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'\"'</SPAN><SPAN class="punctuation token">)</SPAN>‍‍

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>s<SPAN class="punctuation token">)</SPAN>
<SPAN class="number token">12</SPAN>" pipe<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JimNoble

Thanks Joshua, your fix worked perfectly.

JimNoble

Hi Joe, while your fix didn't pop any errors, it didn't actually fix the problem. Maybe I was using it wrong. This is what I put in.

#Calculate field Conduit feature class Underground

arcpy.CalculateField_management("Underground.dbf", "Conduit",
                                '"2in HDPE"', "PYTHON3")

#Set in name replace with quotation

s = '2in HDPE'
s = s.replace('in','\"')

JoshuaBixby

Jim, using Joe's code didn't change anything because you ran it after Calculate Field. The way the code is written now, you are using Calculate Field to update a table and then changing a string within Python but that change is never making it back into a data set.

JimNoble

I see. Thanks for the explanation!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.