8 Replies Latest reply on Sep 16, 2013 2:21 PM by philmodjunk

    Conditional sorting?



      Conditional sorting?


           Is there a way of doing a conditional sort along the lines of:

           If field x is not empty sort this record using fields x & y, else sort using fields z & y ?

           What I want to do is sort fields alphabetically which begin with numbers by using their text equivalents (eg. 10 ABC sorts as Ten ABC) by using a second field with the text equivalent. This would account for <1% of my records so I'd like to avoid a complete duplication of my sort field merely to accommodate those few records.

           Thanks for any insight you can provide.