Skip to Content
avatar image
Former Member

How do I sort by street name?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 19, 2017 at 04:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded