Sorting alphanumeric field in list view

[lakshmi_patel]

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.

Regards

Lakshmi

[antin_s · 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

[lakshmi_patel]

Thanks Antin, this worked.