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?

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

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

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.