Sorting alphanumeric field in list view

lakshmi_patel
Kilo Explorer

Hi All,

I have a string kind of field and i need to sort this numerically in ascending order, right now it is displaying all starting with 1 first then the ones starting with 2 and so on. I want to show the numbers in ascending order. Any suggestions will be appreciated on this.

Screen Shot 2017-08-01 at 10.52.28 AM.png

Regards

Lakshmi

1 ACCEPTED SOLUTION

Hi Lakshmi,



For this to work, you need to have the String Values like 01, 02, 03, ..... 11,   43. If you think you might have 3 digit, you should have it as 001, 002, 003, ...etc.



Hope this helps. Mark the answer as correct/helpful based on impact.



Thanks


Antin


View solution in original post

6 REPLIES 6

PrashantLearnIT
Giga Sage

Hi Lakshmi



It is coming as per ascending only as far as i see your screenshot.


********************************************************************************************************
Please appreciate the efforts of community contributors by marking the appropriate response as the correct answer and helpful. This may help other community users to follow the correct solution in the future.

********************************************************************************************************
Cheers,
Prashant Kumar
ServiceNow Technical Architect


Community Profile LinkedIn YouTube Medium TopMate
********************************************************************************************************

Hi Prashant,



It is first showing all names starting with 1, then all starting with 2.   The sequence is like shown below:



1


11


12


2


21


24


3


31


35


4


41


43



I hope this clarifies my issue.


2 should be shown after 1, not after 12.



Regards


Lakshmi


HI Lakshmi,



What is the data type for that field?


********************************************************************************************************
Please appreciate the efforts of community contributors by marking the appropriate response as the correct answer and helpful. This may help other community users to follow the correct solution in the future.

********************************************************************************************************
Cheers,
Prashant Kumar
ServiceNow Technical Architect


Community Profile LinkedIn YouTube Medium TopMate
********************************************************************************************************

Hi Prashant,



It is string.