Skip to Content
avatar image
Former Member

Sort by street

HI I have a request to sort according to street name.

The problem is of course there is a number first which we want to exclude.

How would you do a formula to remove the number?
We have to assume the number comes first. ( some people have like

100 Main st. # 1 here we only want to exclude 100).

And then I need to group or sort on this formula.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 16, 2017 at 08:34 PM

    Just a sample formula:

    stringvar x:="100 Main street";
    numbervar a;

    for a:=1 to Length(x) do
    if isnumeric (left(x,1)) then x:=right(x,Length(x)-1) ;
    trimleft (x)

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 17, 2017 at 07:15 PM

    Hi Paul,

    Oh there are so many problems with trying to do it this way. The address will have to be in the same format for all the records. Hopefully the apartment number doesn't come before the street number.

    Also, sorting by a string will have M and m sorted differently so spelling is also important unless you convert the address to Uppercase in your formula. Problems with abbreviations. I've worked on trying to group people together in the same household. Sorting by address is the worst because of the things I've mentioned.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded