Devices are not sorting according to order - 100+ devices

Solved
SMJ
Conversationalist

Devices are not sorting according to order - 100+ devices

As per the image below when sorting the device by names device #100 is coming after device #10 not after device #99.

I understand this issue with site design.

Is any have any idea about this?

2020-01-28_77_chrome.png

1 Accepted Solution
Nash
Kind of a big deal

"Simple" fix is usually to append 0 in front of two digit numbers. Try it in Excel.

 

It's... relatively easy to do with a script, but if you dunno how to code, could also click through rapidly or make an intern do it.

View solution in original post

2 Replies 2
PhilipDAth
Kind of a big deal
Kind of a big deal

That is correct behaviour.  Specifically the space after AF10 has an ASCII code of 32, while the character in the same spot - "0" - has an ASCII code of 48.

 

Nothing to do with Meraki.  This is simple, standard and correct sorting alphabetical behaviour.

Nash
Kind of a big deal

"Simple" fix is usually to append 0 in front of two digit numbers. Try it in Excel.

 

It's... relatively easy to do with a script, but if you dunno how to code, could also click through rapidly or make an intern do it.

Get notified when there are additional replies to this discussion.
Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.