How do I sort by street name?

[Former Member]

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?

[Former Member]

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