G Guest Mar 4, 2005 #1 How do I sort a list of residential addresses by street name (ignoring the address number) that precedes the namei of the street)?
How do I sort a list of residential addresses by street name (ignoring the address number) that precedes the namei of the street)?
G Guest Mar 4, 2005 #2 easiest way i guess would be to make a new column for just the street numbers and then filter street name in ascending
easiest way i guess would be to make a new column for just the street numbers and then filter street name in ascending
J Joseph Meehan Mar 4, 2005 #3 Dave888 said: How do I sort a list of residential addresses by street name (ignoring the address number) that precedes the namei of the street)? Click to expand... I suspect this is going to be a complex issue. You not only are going to need to address the number part of the address but other variations such as 123 N Main St 123 North Main St One Main St 123A North Main St 123 N. Main Street Getting rid of the 123 can be done with just a little work. But I don't think you would like the results. It might be easier to create a sort field and have someone copy "Main" over and over.
Dave888 said: How do I sort a list of residential addresses by street name (ignoring the address number) that precedes the namei of the street)? Click to expand... I suspect this is going to be a complex issue. You not only are going to need to address the number part of the address but other variations such as 123 N Main St 123 North Main St One Main St 123A North Main St 123 N. Main Street Getting rid of the 123 can be done with just a little work. But I don't think you would like the results. It might be easier to create a sort field and have someone copy "Main" over and over.
