topic Re: Remove all characters before a certain character with Python using Field Calculator in Python Questions https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197899#M15165 <HTML><HEAD></HEAD><BODY><P>Thank worked Kevin, thank you!</P></BODY></HTML> Wed, 29 Nov 2017 21:29:03 GMT Brian_McLeer 2017-11-29T21:29:03Z Remove all characters before a certain character with Python using Field Calculator https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197897#M15163 <HTML><HEAD></HEAD><BODY><P>I have a series of strings that I need to eliminate a series of text. The text can be variable in length, so doing any trim or strip functions will not work. The string is:&nbsp;</P><P>&nbsp;<STRONG>&nbsp;<SPAN style="font-size: 13px;">&lt;img src="X:\UB_Routing\images\ServiceOrders\150 E MAIN ST.png"&gt;&lt;br&gt;150 E MAIN ST</SPAN></STRONG></P><P>or</P><P>&nbsp;&nbsp;<SPAN style="font-size: 13px;"><STRONG>&lt;img src="X:\UB_Routing\images\ServiceOrders\3207 SE ROSESPRING DR.png"&gt;&lt;br&gt;3207 SE ROSESPRING DR</STRONG></SPAN></P><P>As a few examples, but they can be any address.&nbsp;</P><P></P><P>I am looking for a Python field calculator solution to remove everything before and including the value of&nbsp;<STRONG>&lt;br&gt;</STRONG></P><P>From the examples above, the only values left would be:</P><P><STRONG>150 E MAIN&nbsp;ST</STRONG></P><P><STRONG>3207 SE ROSESPRING DR</STRONG></P></BODY></HTML> Wed, 29 Nov 2017 21:13:22 GMT https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197897#M15163 Brian_McLeer 2017-11-29T21:13:22Z Re: Remove all characters before a certain character with Python using Field Calculator https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197898#M15164 <HTML><HEAD></HEAD><BODY><P>Try using</P><P>!FieldName![!<SPAN>FieldName</SPAN>!.rindex('&gt;')+1:]</P></BODY></HTML> Wed, 29 Nov 2017 21:24:51 GMT https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197898#M15164 KevinDunlop 2017-11-29T21:24:51Z Re: Remove all characters before a certain character with Python using Field Calculator https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197899#M15165 <HTML><HEAD></HEAD><BODY><P>Thank worked Kevin, thank you!</P></BODY></HTML> Wed, 29 Nov 2017 21:29:03 GMT https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197899#M15165 Brian_McLeer 2017-11-29T21:29:03Z Re: Remove all characters before a certain character with Python using Field Calculator https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197900#M15166 <HTML><HEAD></HEAD><BODY><PRE class="lia-code-sample line-numbers language-none"><CODE>my_string <SPAN class="operator token">=</SPAN> <SPAN class="string token">'&lt;img src="X:\UB_Routing\images\ServiceOrders\150 E MAIN ST.png"&gt;&lt;br&gt;150 E MAIN ST'</SPAN> <SPAN class="keyword token">print</SPAN> my_string<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'&lt;br&gt;'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="number token">150</SPAN> E MAIN ST <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sat, 11 Dec 2021 09:53:09 GMT https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/197900#M15166 DarrenWiens2 2021-12-11T09:53:09Z Re: Remove all characters before a certain character with Python using Field Calculator https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/1000602#M59017 <P>Nice solution! I've been trying to repurpose this to remove all characters AFTER a certain character, but I'm stuck. Could you help, please?</P> Thu, 12 Nov 2020 10:15:01 GMT https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/1000602#M59017 YusefSamari 2020-11-12T10:15:01Z Re: Remove all characters before a certain character with Python using Field Calculator https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/1179645#M64700 <P>I was looking for that too and I found it on another thread (<A href="https://community.esri.com/t5/arcmap-questions/removing-text-after-comma/m-p/330225" target="_self">Removing text after comma</A>).&nbsp; I was trying to remove characters after a &amp;.&nbsp; I'm not sure the link will link to the thread.</P><PRE>!YourFieldName!.split(",")[0] ‍</PRE><P>&nbsp;</P><P>&nbsp;</P> Thu, 02 Jun 2022 22:07:32 GMT https://community.esri.com/t5/python-questions/remove-all-characters-before-a-certain-character/m-p/1179645#M64700 DianaRathfelder2 2022-06-02T22:07:32Z