Alphanumeric Sorting

  • 23 January 2023
  • 4 replies
  • 100 views

Badge +2

Is there a particular way to address the alphanumeric fields while sorting?

I feel restricted in effectively sorting my data currently. In the attached screenshot, the alphanumeric fields make it impossible to sort the values in an ascending order.

Is my only option then is to use some other header column ?

 


4 replies

Userlevel 4
Badge +11

There is no other option for the sorting itself. However, you can increase the number sequence of the order no., e.g. to 1000072, then the sorting will be correct.

Badge +2

Thanks.

 

Userlevel 4
Badge +11

With pleasure. @Uniqueusername.: Please change the status of your question to “Solved” 👍🏻

Userlevel 7
Badge +21

Not a very nice solution, but what if you prepare a custom attribute (field) that is the numeric equivalent using Cast or something or add 10000 to the entered value. This would then be the new sorting field.

Reply