Jump to content

Sorting Addresses by Street Name


This topic is 6451 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have not needed to do this, but have you tried the Filter Function, and then sorted the resulting field?

A small test I did seemed to do what you wanted. However, if there is a letter in the the street number, you will have a problem with that.

Filter ( [color:blue]YourAddressField ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz., " )

HTH

Lee

Link to comment
Share on other sites

Another thing which might work ... create a calculation (text) with:

MiddleWords ( theField ; 2 ; WordCount ( theField ) )

... this will drop the first 'word' which is USUALLY the street number.

Link to comment
Share on other sites

This topic is 6451 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.