Parse out street name from an address line

[Sumone]

I am looking for the best way to isolate street name out of an address line that begins with street number. I wish to order output by street name for general grouping purposes.

 

[lbass]

It depends on how consistent the addresses are, but you could try creating a formula to group on:

split({table.address}," ")[2]

This would ignore an initial set of numbers and pick up the second element in the address.

-LB