topic Field Calculator in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/field-calculator/m-p/1111297#M47205 <P>I'm having trouble field calculating everything left of the last space.</P><P>Ex. MAIN ST&nbsp;</P><P>Ex. BARE HALLOW DR</P><P>I am need of just "MAIN" and Just "BARE HALLOW" for my street names field without the post type. I started with full address (425 S MAIN ST) and have most of them narrowed down by the script bellow.&nbsp;</P><P>&nbsp;</P><P><SPAN>Ex: 4256 Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>I want to select everything right and left of space.</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s = 4256 Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s.split(" ", 1)[1].rsplit(" ", 1)[0]</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>Result: Monroe</SPAN><SPAN>&nbsp;</SPAN></P><P>&nbsp;</P><P><SPAN>Ex: Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>I want everything before the space.</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s= Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s.split(" ")[0]</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>Result: Monroe&nbsp;</SPAN><SPAN>&nbsp;</SPAN></P> Tue, 26 Oct 2021 15:49:28 GMT GarrettByrd 2021-10-26T15:49:28Z Field Calculator https://community.esri.com/t5/arcgis-pro-questions/field-calculator/m-p/1111297#M47205 <P>I'm having trouble field calculating everything left of the last space.</P><P>Ex. MAIN ST&nbsp;</P><P>Ex. BARE HALLOW DR</P><P>I am need of just "MAIN" and Just "BARE HALLOW" for my street names field without the post type. I started with full address (425 S MAIN ST) and have most of them narrowed down by the script bellow.&nbsp;</P><P>&nbsp;</P><P><SPAN>Ex: 4256 Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>I want to select everything right and left of space.</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s = 4256 Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s.split(" ", 1)[1].rsplit(" ", 1)[0]</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>Result: Monroe</SPAN><SPAN>&nbsp;</SPAN></P><P>&nbsp;</P><P><SPAN>Ex: Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>I want everything before the space.</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s= Monroe St</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>s.split(" ")[0]</SPAN><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>Result: Monroe&nbsp;</SPAN><SPAN>&nbsp;</SPAN></P> Tue, 26 Oct 2021 15:49:28 GMT https://community.esri.com/t5/arcgis-pro-questions/field-calculator/m-p/1111297#M47205 GarrettByrd 2021-10-26T15:49:28Z Re: Field Calculator https://community.esri.com/t5/arcgis-pro-questions/field-calculator/m-p/1111300#M47206 <P>See if this <A href="https://community.esri.com/t5/python-questions/a-better-way-to-parse-an-address/td-p/17782" target="_self">older post of mine</A> can help.</P> Tue, 26 Oct 2021 15:52:04 GMT https://community.esri.com/t5/arcgis-pro-questions/field-calculator/m-p/1111300#M47206 JoeBorgione 2021-10-26T15:52:04Z Re: Field Calculator https://community.esri.com/t5/arcgis-pro-questions/field-calculator/m-p/1111327#M47208 <P>Try this</P><P><STRONG>Parser</STRONG>: Python</P><P><STRONG>Expression</STRONG></P><LI-CODE lang="python">!StreetName!.rsplit(' ',1)[0]</LI-CODE><P>&nbsp;</P> Tue, 26 Oct 2021 16:38:26 GMT https://community.esri.com/t5/arcgis-pro-questions/field-calculator/m-p/1111327#M47208 JayantaPoddar 2021-10-26T16:38:26Z