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 do I remove null values from Maplex Labeling using Python?

MikeHutchison

def FindLabel ( [INSERTEDMAINSIZE], [INSERTEDMAINMATERIAL] 😞
return str([INSERTEDMAINSIZE]) + " " + str([INSERTEDMAINMATERIAL])

I'm using ArcMap 10.2. There are null values in [INSERTEDMAINSIZE] and [INSERTEDMAINMATERIAL]. Instead of labeling the Null values as "None" I don't want them to show up on the map at all. If there is a value for that features, I want that to label, just not the null values. How do I add this to the script?

Thanks

Najděte více příspěvků označených jako

Accepted answers

All comments

MikeHutchison

Ok I got it to work, last question, where can I enter in [-2:] so I get the last 2 digits of the date? In red I've included what I've tried and it failed. I haven't had any formal python training so I'm trying to teach myself. I appreciate your help.

def FindLabel ( [NOMINALDIAMETER], [MAINMATERIAL], [ABANDONMENTDATE], [ABANDONMENTORDER] 😞
return [NOMINALDIAMETER] + " " + [MAINMATERIAL] + " " + ' ' .join(filter(None, (([ABANDONMENTDATE][-2:]), [ABANDONMENTORDER])))

RandyBurton

As Darren is suggesting, try:

<SPAN class="keyword token">def</SPAN> FindLabel <SPAN class="punctuation token">(</SPAN> <SPAN class="punctuation token">[</SPAN>MAINSIZE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>MAINMATERIALTYPE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>SYSTEMMAOP<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>INSTALLATIONDATE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>WORKORDERNUMBER<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>INSERTEDMAINSIZE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>INSERTEDMAINMATERIAL<SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">return</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>filter<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>MAINSIZE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN>MAINMATERIALTYPE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN>SYSTEMMAOP<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>INSTALLATIONDATE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN>WORKORDERNUMBER<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>INSERTEDMAINSIZE<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>INSERTEDMAINMATERIAL<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DarrenWiens2

Basically, ' '.join(x) makes a new string inserting a space between the items in x.

</CODE></P><P><CODE style="border: 0px; font-weight: inherit; font-size: 14px;">

filter(None,y) removes None from a tuple, y. You need to make a new tuple to fit your needs.<BR /><BR />

<SPAN class="keyword token">return</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>filter<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> THE_TUPLE_TO_REMOVE_NONE_FROM<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

 

MikeHutchison

That worked great. Now I have an additional problem, how do I include this in my overall script to annotate a feature using other fields, not just the ones above, that don't have null values. This is my entire script. Where would I add in what you sent me.

def FindLabel ( [MAINSIZE], [MAINMATERIALTYPE], [SYSTEMMAOP], [INSTALLATIONDATE], [WORKORDERNUMBER], [INSERTEDMAINSIZE], [INSERTEDMAINMATERIAL] 😞
return [MAINSIZE] + " " + [MAINMATERIALTYPE] + " " + [SYSTEMMAOP] + "D" + " " + ([INSTALLATIONDATE][-2:]) + " " + [WORKORDERNUMBER]

The 5 fields I'm using here all have a value. I want to add the inserted information (INSERTEDMAINSIZE and INSERTEDMAINMATERIAL) if applicable, on another line ("r\n"). Where would I put the join(filter(None.... to get my final label?

DarrenWiens2

return ' '.join(filter(None, ([INSERTEDMAINSIZE],[INSERTEDMAINMATERIAL])))<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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