AnsweredAssumed Answered

sort -- number with letters

Question asked by firth5 on Feb 25, 2010
Latest reply on Feb 22, 2011 by Davisms

Title

sort -- number with letters

Post

I've got a field that always has numbers, but also occasionally has letters.

 

I'd like it to sort so that the numbers are always in order, but that when the letters appear, those sort as well.

 

for example:

 

101, 100, 103, 101A, P103, 101C, 101b, 103A

 

would sort as follows:

 

100

101

101a

101b

101c

103

P103

103a

 

 

If I make the field a NUMBER field, it ignores all the letters completely.

If I make it a TEXT field, it sorts everything correctly, but puts the "P" prefixes at the end of the list. 

 

I invite your thoughts.

 

Thanks,

eric 

Outcomes