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 text after comma

MelissaDrake1

I have a field contains owners name

Doe, John and Jane

I am trying to remove everything so just the last name shows
Doe

I have tried several codes but nothing is working so far. I have Desktop 10.4

Could anyone give me some help please?

Finde mehr Beiträge mit dem Tag

Accepted answers

DanPatterson_Retired

python parser in the field calculator, no need for a codeblock if it is a text field

!YourFieldName!<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="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

MelissaDrake1

Thank you! I really appreciated the help.

MelissaDrake1

Thank you! It worked

DanPatterson_Retired

python parser in the field calculator, no need for a codeblock if it is a text field

!YourFieldName!<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="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

HåkonDreyer

Guessing you are using the field calculator, add a little Pre-Logic code:

def justname(txt):
   return txt[0: txt.find(',')]

Field calculator

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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