Hi, I got a sample script from an older post but I cannot get it working. I'm trying to remove duplicate values within records in a FC. For example, in the first row above, I need to get rid of one "63350" and one "70169" keeping the ";" as delimiters. import arcpy InputFC = r "H:\PROGRAMMES\10_OTHER_PROJECTS\24_ATTRIBUTION_CHECKS\From_RTJ.gdb\REFID_sample_1_1" InputField = "REF_ID" cursor = arcpy . da . UpdateCursor ( InputFC , [ "REF_ID" ] ) for row in cursor : strList = row . Value ( InputField ) . split ( "; " ) strSet = set ( strList ) str = "; " conStr = str . join ( strSet ) row . setValue ( InputField , conStr ) cur . updateRow ( row ) del row del cursor I'm getting an error related to line 12: AttributeError: 'list' object has no attribute 'Value' Any help would be greatly appreciated. Thanks

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

Removing duplicate values within records

anTonialcaraz

Hi,

I got a sample script from an older post but I cannot get it working.

I'm trying to remove duplicate values within records in a FC.

For example, in the first row above, I need to get rid of one "63350" and one "70169" keeping the ";" as delimiters.

<SPAN class="keyword token">import</SPAN> arcpy


InputFC <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\PROGRAMMES\10_OTHER_PROJECTS\24_ATTRIBUTION_CHECKS\From_RTJ.gdb\REFID_sample_1_1"</SPAN>
InputField <SPAN class="operator token">=</SPAN> <SPAN class="string token">"REF_ID"</SPAN>

cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>InputFC<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"REF_ID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>

    strList <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>Value<SPAN class="punctuation token">(</SPAN>InputField<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"; "</SPAN><SPAN class="punctuation token">)</SPAN>
    strSet <SPAN class="operator token">=</SPAN> set<SPAN class="punctuation token">(</SPAN>strList<SPAN class="punctuation token">)</SPAN>

    str <SPAN class="operator token">=</SPAN> <SPAN class="string token">"; "</SPAN>
    conStr <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>strSet<SPAN class="punctuation token">)</SPAN>

    row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>InputField<SPAN class="punctuation token">,</SPAN> conStr<SPAN class="punctuation token">)</SPAN>

    cur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN> row
<SPAN class="keyword token">del</SPAN> cursor<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>

I'm getting an error related to line 12: AttributeError: 'list' object has no attribute 'Value'

Any help would be greatly appreciated.

Thanks

Find more posts tagged with

Accepted answers

JoshuaBixby

I revisited the documentation, and you are correct, i.e., row.Value is incorrect. Correct syntax for the old cursors would involve getValue and setValue, not just Value. So it appears to be mixing syntax and using incorrect syntax.

All comments

DanPatterson_Retired

Ahhhh, that is so old, I just thought it was an error Relic of ArcMap?

JoshuaBixby

The issue wasn't about using the with, but how the OP was trying to retrieve values from the cursor:

cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>InputFC<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"REF_ID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Created DA cursor</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    strList <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>Value<SPAN class="punctuation token">(</SPAN>InputField<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"; "</SPAN><SPAN class="punctuation token">)</SPAN>      <SPAN class="comment token"># Used old cursor syntax</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

Accessing data using cursors—ArcPy Get Started | ArcGIS Desktop

actually both are supported

<SPAN class="keyword token">import</SPAN> arcpy

cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'fieldA'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldB'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Search and update cursors also support with statements.</SPAN>

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'fieldA'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldB'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoshuaBixby

You are mixing the syntax between the legacy cursors and the newer Data Access cursors, that is why you are getting the specific error. Review UpdateCursor—Help | ArcGIS for Desktop for proper syntax.

DanPatterson_Retired

strList = row[0].split("; ")

doesn't work? An not directly related example that splits on spaces IF the row isn't empty.

in_fc0 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Some_featureclass_in_a_spaceless_path"</SPAN>
cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>in_fc0<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Text_1"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
        strList <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<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>strList<SPAN class="punctuation token">)</SPAN>
    
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'not'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'null'</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'not'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'null'</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'E_no_space'</SPAN><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>

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.