I have around 18,000 address that are incorrectly formatted. The reason for the incorrect formatting is we used to look up address based on the road name like 300 E. This way every address on 300 E. would show up in at list.
For example:
300 E 4772 N
This formating made sense when doing certain tasks. The time has now come that we need to have these address formatted correctly;
Like:
4772 N 300 E
I have tried geocoding them with around 3% to 5% matching. So this process is not working for me. Is there a way within ESRI software that I can fix these addresses so that they are converted correctly.
Any help would be appreciated.