Home > Reporting > Sorting on Alphanumeric order > Re: Sorting on Alphanumeric order

Re: Sorting on Alphanumeric order

Add a topic

Home › Forum › Reporting › Sorting on Alphanumeric order › Re: Sorting on Alphanumeric order

November 10, 2010 at 9:21 am #5487

Peanuts890
Participant

Hi Dennis,

I had already tried this and it didn’t seem to work. Using the data in the original post, ie. PLA999, PLA1000, PLA1001, the substring results (hidden column) display correctly as 999, 1000, 1001. Sorting on this data in descending order gives 999, 1001, 1000.

Was wondering if the results of the substring were still alphanumeric and causing a problem.

Thanks

Add a topic