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.
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)
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