(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Sort criteria (Read 523 times)
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Sort criteria
Mar 10th, 2011 at 4:15pm
Print Post Print Post  
I have a client that wants to sort an address field while disregarding the number portion of the address. In other words they just want the address sorted by the text portion of the address.

Is this possible?

Thank you
  
Back to top
WWW WWW  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Sort criteria
Reply #1 - Mar 10th, 2011 at 4:38pm
Print Post Print Post  
Sure.

1. Create a separate field called something like SortAddress.
2. Write programming in On Element Change for the Address field to set Sort Address to the Address without the numbers.
3. Run a Mass Update to update the existing records.

Then you can sort by SortAddress.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: Sort criteria
Reply #2 - Mar 10th, 2011 at 5:05pm
Print Post Print Post  
Thank you Erika!
  
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge