AnsweredAssumed Answered

Addresses, portals and sorting.

Question asked by trm1945 on Apr 29, 2014
Latest reply on Apr 30, 2014 by trm1945

Is there some convention on sorting addresses by their street number content? For example does # 3, 320 Cherry Lane come before or after 333 Main Street or Apt 330, 1120 Second Ave? I'd like to assume a sort on the field's street number only content meaning some way of telling street numbers from house and apartment numbers. The purpose of this sorting is to quickly identify an address by the street number with apartment etc. numbers as secondary information. In the example here, the sort would be: 320 Cherry Lane, 333 Main Street, 1120 Second Avenue. I can see the spaces and lack of them in these addresses but an elegant solution is just beyond me. Also, initial data entry in separate fields may be too much to ask. I really don't care how complicated a solution is as long as that complexity stays inside the program.

Outcomes