In a report I have an address field with this format:
400 Queen Street
24 Bridge Street
I want to order my report based on Street name, not number. I was thinking to make a calculated field, split out the address and choose the second item. I was messing around with things like ElementAt() but haven't had success.
Please sign in to leave a comment.