Skip to main content

Alphanumeric Sorting

  • January 23, 2023
  • 4 replies
  • 127 views

Forum|alt.badge.img+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

MikeCH
Hero (Employee)
Forum|alt.badge.img+13
  • Hero (Employee)
  • 150 replies
  • January 23, 2023

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.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Employee)
  • 2 replies
  • January 24, 2023

Thanks.

 


MikeCH
Hero (Employee)
Forum|alt.badge.img+13
  • Hero (Employee)
  • 150 replies
  • January 24, 2023

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


eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 677 replies
  • January 26, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings