2 Replies Latest reply on Apr 10, 2015 10:06 AM by philmodjunk

    Protal sort

    Kirk_1

      Title

      Protal sort

      Post

      I have a portal with long descriptions. I have it sorted by those descriptions. It alphabetizes them to a point.

      Is there a character limit on alphabetizing something. If so is there a way to extend that?

        • 1. Re: Protal sort
          Kirk_1

          In researching, part of my issue i have numbers as a part of the description. If i change the field to a number field, it sorts by the number not the characters and the numbers... I am hoping to sort by characters and numbers... I don't want to do a value list because i have to change that not my employees.

          • 2. Re: Protal sort
            philmodjunk

            Care to provide an example of this data?

            One trick for getting numeric text to sort correctly is to add leading zeroes

            1,2,10,30

            will text sort as 1, 10, 2, 30

            01, 02, 10, 30

            will text sort as expected.