AnsweredAssumed Answered

Sorting by numbers with more than one separator

Question asked by ampersand on Nov 6, 2017
Latest reply on Nov 13, 2017 by Paul Jansen

Is it possible to sort records numerically by a field in which the values have more than one separator?

 

I am trying to sort the numbers 1.0.1 through 1.0.14 in this way:

 

1.0.1

1.0.2

1.0.3

1.0.4

1.0.5

1.0.6

1.0.7

1.0.8

1.0.9

1.0.10

1.0.11

1.0.12

1.0.13

1.0.14

 

But when I format the field as a number and perform the sort, it sorts like this, similar to the Dewey Decimal System:

 

1.0.1

1.0.10

1.0.11

1.0.12

1.0.13

1.0.14

1.0.2

1.0.3

1.0.4

1.0.5

1.0.6

1.0.7

1.0.8

1.0.9

 

Many thanks for any guidance.

Outcomes