Skip to Content
0

How do I sort by street name?

Apr 18, 2017 at 10:41 PM

30

avatar image

I have one field that has both the street number and street name.

Example:

1 Main St

2 Center St

3 Main Street

I dont want it to sort by the number, I want it to sort or group by the street name, like this:

1 Main St

3 Main Street

2 Center St

But I cannot figure out how. Can someone help?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Niraj Parihar Apr 19, 2017 at 04:53 AM
0

Create a formula with definition

@SortText as

Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace(Replace (StreetName,"0" ,"" ),"1",""),"2" ,"" ),"3" ,"" ),"4" ,"" ),"5" ,"" ),"6" ,"" ),"7" ,"" ),"8" ,"" ),"9" ,"" )

and then Sort the data based on formula SortText

Basically this formula will replace all numbers from your string leaving behind only strings to be sorted.

Regards

Niraj

Share
10 |10000 characters needed characters left characters exceeded