3 Replies Latest reply on Aug 13, 2014 8:31 AM by philmodjunk

# Sorting records by numbers with periods

### Title

Sorting records by numbers with periods

### Post

How can I sort all records by an accession # that includes periods?  For Example 1991.235, 1991.236, 1992.103, 1992.104

• ###### 1. Re: Sorting records by numbers with periods

Is there only ever 1 decimal in these numbers?

Should

1992.20

come before or after

1992.191

??

• ###### 2. Re: Sorting records by numbers with periods

yes there is only one decimal .... 1992.191 should come before 1992.20

• ###### 3. Re: Sorting records by numbers with periods

Then if you are sorting in ascending order and 1992.191 should come before 1992.20, I don't see the issue. Make this a field of type number and sort in ascending order.

If the second value is seen as a second integer, such that 191 is greater than 20 instead of 0.20 is greater than 0.191, then you'd need to set up two calculation fields that extract (parse) the the numbers from before and after the decimal so that you can use those two fields in tandem in a specified sort order.