Sort by Address

[christopherb]

A thought... let say you have a address attribute (123 main street.) And now you wish to order them by street name in a list ASC. So the obvious trouble would become that following order would take place.

122 Power Street
123 main Street

The numeric portion of the address would create the order prior to the street name.

Can you "pass over" a numeric part of the address attribute to create an order by the street name without creating a separate attribute for the street number?

(hope that makes sense)

Cheers,

[tford]

Chris,

I think you could sort on a new attribute and have it built by a rule something like:

Customer.Address_Sort=WORDS_FROM_RIGHT(Customer.Address,(WORD_NUMBER(Customer.Address)-1))

Tom

[christopherb]

Tom,
I was thinking the same idea though i will need to play with it more to get it to work properly based on the varations in street name like the following

main st.
main street
main

and so on...


Thank you
Chris

[tford]

As long as the # is the first "word" in the test attribute, the rest way the rest of the words are structured should not matter should it?

Tom