arcpy.CalculateField_management ERROR:

Anonymous User

I'm trying to display the value of 1 or 2 fields based on the input of another. 

arcpy.CalculateField_management(inPoints, fieldName10, "my_func(!RdType!, !Address!, !BENQUA! )", "PYTHON_9.3", "def my_func(val, fld1, fld2):\\n    if val in ('Pr'):\\n        return fld1 & " " & fld2\\n    else:\\n        return fld1")

DanPatterson_Retired

Anthony... did you try the field calculator expression to make sure it works?  And if it does, you can triple quote to get the correct formatting and indentation.

For example (untried)

<SPAN class="comment token"># ---- tried once</SPAN>
val <SPAN class="operator token">=</SPAN> <SPAN class="string token">'a'</SPAN>
fld1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'b'</SPAN>
fld2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'c'</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">my_func</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> fld1<SPAN class="punctuation token">,</SPAN> fld2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> val <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Pr'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fld1 <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> fld2
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fld1
&nbsp;&nbsp;&nbsp; 

my_func<SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> fld1<SPAN class="punctuation token">,</SPAN> fld2<SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'b'</SPAN>

<SPAN class="comment token"># ---- then recall the function from command line and triple quote</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="string token">"""def my_func(val, fld1, fld2):
&nbsp;&nbsp;&nbsp; if val in ('Pr'):
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1 + " " + fld2
&nbsp;&nbsp;&nbsp; else:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1
"""</SPAN>
<SPAN class="string token">'def my_func(val, fld1, fld2):\n&nbsp;&nbsp;&nbsp; if val in (\'Pr\'):\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1 + " " + fld2\n&nbsp;&nbsp;&nbsp; else:\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1\n'</SPAN>

<SPAN class="comment token"># ---- or </SPAN>

<SPAN class="string token">"""
def my_func(val, fld1, fld2):
&nbsp;&nbsp;&nbsp; if val in ('Pr'):
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1 + " " + fld2
&nbsp;&nbsp;&nbsp; else:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1
"""</SPAN>
<SPAN class="string token">'\ndef my_func(val, fld1, fld2):\n&nbsp;&nbsp;&nbsp; if val in (\'Pr\'):\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1 + " " + fld2\n&nbsp;&nbsp;&nbsp; else:\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return fld1\n'</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>‍</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>