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; } } }

ArcGIS Pro 2.3 - Proper syntax for codeblock in Python?

VincentLaunstorfer

Hi,

I have a tool based on y Python script which used to work perfectly in ArcGIS Desktop...

In Pro, it does not! In a CalculateField_management statement, I use the following codeblock to calculate the value to assign. In this case, it is a String and it looks like causing the problem (I have a similar statement with similar codeblock calculating integer value and it works fine).

Has the syntax for dealing with String changed slightly with Python 3 used in Pro? Something with single or double quotes? A combination of both?

Thanks

        codeblock_source <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""def getSource(elev,user_source,source,ons_off):
          if elev != -9999 and ons_off == 'Onshore' and source == 'NA':
            return user_source
          elif ons_off == 'Offshore':
            return 'OFF'            
          else:
            return source"""</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Vind meer berichten getagd met

Accepted answers

VincentLaunstorfer

The error was shown in the dialog box while running the script as:

<function GetMessages at 0x000002F1582FCAE8>

I don't know how to use traeback...

Anyway, I found the syntax error in the code. The return = 'OFF' within single quotes in the elif statment should be return = "OFF" within double-quotes. Silly but it took some time to figure out where the problem was from, among variables, codeblock, logic...

 codeblock_source <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""def getSource(elev,user_source,source,ons_off):
 if elev != -9999 and ons_off == 'Onshore' and source == 'NA':
 return user_source 
 elif ons_off == 'Offshore':
 return "OFF"
 else:
 return source"""</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It all works now! And it does mean there are some subtle difference in Python in ArcGIS Desktop and ArcGIS PRO...

All comments

VincentLaunstorfer

Probably. And it is totally normal.

For any script (such as Python in ESRI) or more substantial programming, ALWAYS use simple text editor and/or dedicated IDE program. These use plain text while any advanced text editor such as MS Word or others use rich text editing (with embedded formatting tags and so on).

LukeWebb

Ive found that if I store the code in a temporary Microsoft Format. (Word, Excel etc)

The single quotes, are not compatible with some of the ESRI stuff. But if you copy the same text into notepad, then copy that into Arc, many tools will work.

curtvprice

I chalk this up to the very complex nested handling of strings required by using Calculate Field code blocks in a Python script. I do use Calculate Field in python scripts, but when a code block is needed as a rule I go to arcpy.da.UpdateCursor because the code is much easier to read (and of course, debug!).

flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ELEV"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ONS_OFF"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SOURCE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"USER_SOURCE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OFIELD"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> rows<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> rows<SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"-9999"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Onshore"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NA"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">elif</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"Offshore"</SPAN><SPAN class="punctuation token">:</SPAN>
            row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"OFF"</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
        rows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</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>‍</SPAN></SPAN>

DanPatterson_Retired

when mixing single and triple quotes in python, it is good to just dump the stuff in between them and examine how python tries to handle the quoting without having to 'escape' a quote character.

Examine the logic, it is important

<SPAN class="comment token"># ---- assume for example that you have 1 pair of triple quotes """ """ or ''' '''</SPAN>

<SPAN class="comment token"># ---- you add in 3 pairs of single quotes and 1 paire of double quotes</SPAN>

<SPAN class="string token">"""a 'b' 'c' 'd' "e" """</SPAN>

<SPAN class="comment token"># ---- result, there is a bit of a struggle in python, so it escapes \ each single quote</SPAN>

<SPAN class="string token">'a \'b\' \'c\' \'d\' "e" '</SPAN>

<SPAN class="comment token"># ---- so you make sure that you use only single quotes between the triple quotes</SPAN>

<SPAN class="string token">"""a 'b' 'c' 'd' 'e' """</SPAN>

<SPAN class="comment token"># ---- result, there is no escaping necessary around the single quotes and the</SPAN>
<SPAN class="comment token"># triple quote pair is just reduced to a pair of double quotes</SPAN>

<SPAN class="string token">"a 'b' 'c' 'd' 'e' "</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

VincentLaunstorfer

Hi,

True, I could write my code with arcpy.da.UpdateCursor. I haven't thought about that.

In the meantime, I managed to fix my code!

Thanks

VincentLaunstorfer

The error was shown in the dialog box while running the script as:

<function GetMessages at 0x000002F1582FCAE8>

I don't know how to use traeback...

 codeblock_source <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""def getSource(elev,user_source,source,ons_off):
 if elev != -9999 and ons_off == 'Onshore' and source == 'NA':
 return user_source 
 elif ons_off == 'Offshore':
 return "OFF"
 else:
 return source"""</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It all works now! And it does mean there are some subtle difference in Python in ArcGIS Desktop and ArcGIS PRO...

curtvprice

If you are working with this level of complexity and are not using Calculate Field in model builder, arcpy.da.UpdateCursor makes for much cleaner code.

That said, when I look at this code I see nothing that should not work in both Python 2 and 3. Are you sure the issue is the code block?

bixb0012

How exactly is it not working? Is it giving you an error? If so, what is the error and traceback if available. If it is giving unexpected results, what is it giving and what do you expect?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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