I have an address directory set up as a view on my D9 website. One of the columns has full addresses like this:
1 Main Street Columbus, OH 00000
I’d like to be able to allow click sorting by the Street name in the address first and then possibly the number. Like this
1 Alpha Rd 7 Alpha Rd 1 Beta Rd 5 Beta Rd 7 Columbus Hwy
By default it sorts alphanumerically considering the first character it sees. Do you know of any way I can accomplish this?