Geocoding Intersections

[JonahWaterman]

I have Geocoded a accident table  and have gotten somewhat positive results.  The issue I am seeing is that intersections in the table  without a space separating the forward slash will not be searchable.


For Example:   North Carolina Dr/Vermont St will not geocode
However:        North Carolina Dr / Vermont St will geocode properly



How can I properly geocode this list of accidents without manually changing thousands of records within the attribute table. Thanks again

[DanPatterson_Retired]

if that intersection is in the table use the field calculator (python parser) to replace the single / with a space wrapped one

>>> "North Carolina Dr/Vermont St".replace("/", " / ")
'North Carolina Dr / Vermont St'
>>>

substitute your fieldname for the example text string shown

[JonahWaterman]

if that intersection is in the table use the field calculator (python parser) to replace the single / with a space wrapped one

>>> "North Carolina Dr/Vermont St".replace("/", " / ")
'North Carolina Dr / Vermont St'
>>>

substitute your fieldname for the example text string shown

Thanks my Canadian friend!

[DanPatterson_Retired]

No problem...