I work as a GIS Administrator for a law enforcement agency. To assist the various divisions, i geocode (address match) various address databases to a street network which contains address range information.
The problem is that the databases containing Street names that are numbers are just that (i.e., 1, 2, 33, etc). I need to format them so they are in the following format: 1st, 2nd, 3rd. By the way they parse the addresses like so:
Prefix Street_no Streetname Street_type
SW 1230 1 Ave
The streetname 1 should be 1st not 1
Is there a solution other than search and replace every single number type. What i do know is that the address name that are numbers only go up to 300. Thus, width is three digit number the ideal situation would be to create some type of logical statement where ?0 equals ?0th this would replace all numbers such as 10th, 20th, 30th...90th"
I am more GIS savvy than excel but i am willing to learn if there are any solutions to this problem. I will continue to go through the archive to see if this has already been addressed (no pun intended).
But any advice would be great
The problem is that the databases containing Street names that are numbers are just that (i.e., 1, 2, 33, etc). I need to format them so they are in the following format: 1st, 2nd, 3rd. By the way they parse the addresses like so:
Prefix Street_no Streetname Street_type
SW 1230 1 Ave
The streetname 1 should be 1st not 1
Is there a solution other than search and replace every single number type. What i do know is that the address name that are numbers only go up to 300. Thus, width is three digit number the ideal situation would be to create some type of logical statement where ?0 equals ?0th this would replace all numbers such as 10th, 20th, 30th...90th"
I am more GIS savvy than excel but i am willing to learn if there are any solutions to this problem. I will continue to go through the archive to see if this has already been addressed (no pun intended).
But any advice would be great