Sort only on the street name of address1
Posted: Fri Jun 19, 2020 7:24 pm
Hi, Using ver 11.1 on Win10 Pro. I need to print a list of members by street name. When I sort it I get a list sorted by the house number as well street and results are all over the place.
I did sort it by city & address1 so it's narrowed down a bit but not good enough for our purpose. Is there a variable I can make or other to eliminate the first 4 digits of the Address1 and then sort only the alpha characters? Of course, when I print it out I need to show the house number too. There's also a problem with 3 digit and 4 digit house number. We have the list and making it work. (Don't spend too much time on this one, might not be worth it?)
John
I did sort it by city & address1 so it's narrowed down a bit but not good enough for our purpose. Is there a variable I can make or other to eliminate the first 4 digits of the Address1 and then sort only the alpha characters? Of course, when I print it out I need to show the house number too. There's also a problem with 3 digit and 4 digit house number. We have the list and making it work. (Don't spend too much time on this one, might not be worth it?)
John