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

How to label "_, Mount" as "Mount _" ?

CoryBoschman

I am trying to make labels for all the named peaks across British Columbia. The name string in the attribute table has many entries like "Rad, Mount" or "Rad Peak, The", and I'd like to display them on the map as "Mount Rad" or "The Rad Peak". There are about 13,000 features in the table with only maybe a quarter that need to be changed.

Any suggestions on the best way to accomplish this?

Vind meer berichten getagd met

Accepted answers

DanPatterson_Retired

So much for making things simpler, but since you seem to be adept with 'defs'

<SPAN class="comment token">#---- This is your python code block for the field calculator</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">fix</SPAN><SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="string token">", "</SPAN> <SPAN class="keyword token">in</SPAN> fld<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="operator token">=</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">", "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="operator token">=</SPAN> fld
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> val



fld <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Try, Final"</SPAN>

fix<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp; <SPAN class="comment token">#---- This would be your expression</SPAN>

<SPAN class="string token">'Final Try'</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>

All comments

CoryBoschman

Hi Dan,

I'm getting an error that says the value type is incompatible with the field type (see screen shot). The field I'm calculating (Label) is a text field with the default length of 50 characters.

Any tips?

Thanks,

Cory

DanPatterson_Retired

Show your field calculator in a screen grab

add a text field to hold the calculations
set the field calculator to Python
put this in the expression replacing 'fld' with your fieldname that contains the original data
ie [[i, " ".join(i.split(", ")[::-1])][", " in i] for i in !TheOriginalFieldThatIsMessedUp! ]
note field names in python are enclosed in double exclamation marks ! .... !

CoryBoschman

Hi Chris,

I've looked through the names and it appears that everything that is after a comma should be moved to the front of the string. I have pretty limited experience with python so writing an expression that will accomplish this is beyond me. I've been playing around with what Dan pasted below, but can't seem to get it to work.

Thanks,

Cory

DanPatterson_Retired

Ahhh a brain nimbler...

replace fld with your source field name in ! marks ie !YourField!

Python parser, in the field calculator for a new text field obviously

<SPAN class="comment token"># ---- a sample 'field'</SPAN>

fld <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Last, First"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Ok"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"two last, first"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"right order"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Rad Peak, The"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># ---- the field calculator expression, python parser</SPAN>

<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">", "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">", "</SPAN> <SPAN class="keyword token">in</SPAN> i<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> fld <SPAN class="punctuation token">]</SPAN>

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

<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'First Last'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Ok'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'first two last'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'right order'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'The Rad Peak'</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>‍</SPAN></SPAN>

might not work in all circumstances, so try it on a few and worry about the corner cases later

ChrisDonohue__GISP

One way to do this is with a script. If a consistent symbol or pattern can be identified for cases where a change needs to be made, then that would be employed in the script to detect what records need to be modified and then do the modification. For example, if all the records that need to be modified are situations where the information after a comma needs to instead be placed in front of a comma.

As to specific code, that will depend on the script language of choice. Are you familair with Python or another script language used in GIS?

As one means to do this, check out the label expression examples in this link. They are not exactly what you need, but will give a feel for how to employ the script in ArcGIS when labelling.

Building label expressions—Help | ArcGIS for Desktop

Chris Donohue, GISP

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.