topic Removing text after comma in ArcMap Questions https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330224#M747 <HTML><HEAD></HEAD><BODY><P>I have a field contains owners name</P><P>Doe, John and Jane</P><P>I am trying to remove everything so just the last name shows<BR />Doe</P><P>I have tried several codes but nothing is working so far. I have Desktop 10.4</P><P>Could anyone give me some help please?</P></BODY></HTML> Tue, 18 Sep 2018 20:27:38 GMT MelissaDrake 2018-09-18T20:27:38Z Removing text after comma https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330224#M747 <HTML><HEAD></HEAD><BODY><P>I have a field contains owners name</P><P>Doe, John and Jane</P><P>I am trying to remove everything so just the last name shows<BR />Doe</P><P>I have tried several codes but nothing is working so far. I have Desktop 10.4</P><P>Could anyone give me some help please?</P></BODY></HTML> Tue, 18 Sep 2018 20:27:38 GMT https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330224#M747 MelissaDrake 2018-09-18T20:27:38Z Re: Removing text after comma https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330225#M748 <HTML><HEAD></HEAD><BODY><P>Guessing you are using the field calculator, add a little Pre-Logic code:</P><PRE class="lia-code-sample line-numbers language-none">def justname(txt): &nbsp;&nbsp; return txt[0: txt.find(',')]</PRE><P></P><P><IMG alt="Field calculator " class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/422362_snip_20180918231201.png" /></P></BODY></HTML> Sun, 12 Dec 2021 16:20:51 GMT https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330225#M748 HåkonDreyer 2021-12-12T16:20:51Z Re: Removing text after comma https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330226#M749 <HTML><HEAD></HEAD><BODY><P>python parser in the field calculator, no need for a codeblock if it is a text field</P><PRE class="language-python line-numbers"><CODE>!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></CODE></PRE></BODY></HTML> Wed, 19 Sep 2018 01:27:32 GMT https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330226#M749 DanPatterson_Retired 2018-09-19T01:27:32Z Re: Removing text after comma https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330227#M750 <HTML><HEAD></HEAD><BODY><P>Thank you! It worked</P></BODY></HTML> Wed, 19 Sep 2018 18:32:26 GMT https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330227#M750 MelissaDrake 2018-09-19T18:32:26Z Re: Removing text after comma https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330228#M751 <HTML><HEAD></HEAD><BODY><P>Thank you! I really appreciated the help.</P></BODY></HTML> Wed, 19 Sep 2018 18:35:00 GMT https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330228#M751 MelissaDrake 2018-09-19T18:35:00Z