Geocoding Intersections

Question

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 · Answer

No problem...

JonahWaterman · Answer

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 · Answer

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