I have a dataset
What I am trying to do is pull out the street names from the original field. Any ideas?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Calculate Field tool; for FieldName
select StreetName_1 first
Choose Expression Type Python
Enter this expression: !Intersecti![0,!Intersecti!.find("&") - 2]
This should select the substring from position 0 through to just before the space before the ampersand and apply it to the StreetName_1 field.
Next, do the same operation but for StreetName_2:
Enter this expression: !Intersecti![!Intersecti!.find("&") + 2]
This will select the substring beginning 2 characters after the ampersand through the end of the Intersecti string field.