hah, but, it doesn't really sort them
correctly tho. :)
In my experience, Excel produced results
*something* like this ...
192.168.1.0
192.168.10.0
192.168.100.0
192.168.2.0
192.168.20.0
...etc
Instead of ...
192.168.1.0
192.168.2.0
192.168.10.0
192.168.20.0
192.168.100.0
...etc
--
Quoting Chris Breece <cbreece1_at_gmail.com>:
"sort -t . -n -k1,1, -k2,2 -k3,3 -k4,4"
Wow. I dunno in excel I just click the sort button :)
On Sat, Jun 6, 2009 at 11:31 PM, Kelly <kelly_at_cliffhanger.com> wrote:
> I don't think you can sort the routes
> via the router's command line. Unless
> Cisco integrates the unix sort command
> into the IOS like they did grep.
>
> But A better (than Excel) "real life"
> option is the unix sort command. If you
> don't have access to a unix or linux
> system, you can get a 'port' of the unix
> sort command for an MS Windows box. See
> the link below.
>
> For more info on using the unix sort
> command for IP addrs, see Paul
> Heinlein's web site.
>
> Sort IP Addresses with GNU sort
> http://www.madboa.com/geek/sort-addr/
>
> i.e.,
>
> sort -t . -n -k1,1, -k2,2 -k3,3 -k4,4
>
> GNU (unix) utilities for Win32
> http://unxutils.sourceforge.net/
>
> Kelly
>
>
>
> --
> Quoting Chris Breece <cbreece1_at_gmail.com>:
> Hey Kevin,
>
> Good idea. In real life, I find myself using excel and importing and
> then
> sorting quite a bit. Using it to put routes in order for sum'ing is
> a good
> idea. Not going to help in the lab, but a good real-life tool for
> sure.
>
> Chris
>
>
>
> On Sat, Jun 6, 2009 at 10:47 PM, kevin dalby <ieorbust_at_gmail.com>
> wrote:
>
> > Another option would be to paste it into excel and sort it that
> way.
> >
> >
> >
> > On Sat, Jun 6, 2009 at 9:24 PM, Cisco Fanatic <
> ebay_products_at_hotmail.com
> > >wrote:
> >
> > > To sort out the outputs. The routes might be not that much in
> the Lab,
> > but
> > > I
> > > am also trying to find it in real scenarios when you get huge
> number of
> > > routes
> > > and it becomes cumbersome to sort out if you have miss anything
> (while
> > > applying summarization etc).
> > >
> > > > Date: Sun, 7 Jun 2009 09:50:45 +1000
> > > > Subject: Re:
> > > > From: dale.shaw_at_gmail.com
> > > > To: ebay_products_at_hotmail.com
> > > > CC: ccielab_at_groupstudy.com
> > > >
> > > > Hi,
> > > >
> > > > On Sat, Jun 6, 2009 at 10:15 AM, Cisco Fanatic
> > > > <ebay_products_at_hotmail.com> wrote:
> > > > > All, I am sure that someone might have thought about it
> before.
> > > > >
> > > > > I am getting some 30+ routes
> > > > > and I need to sort them in ascending or descending order
> > > > >
> > > > > Anybody?
> > > >
> > > > No way of doing this at the IOS CLI, as far as I'm aware. I
> make
> > > > extensive use of a (non-free) text editor called UltraEdit, so
> outside
> > > > of the lab, I'd use its built-in sort function for a task like
> this.
> > > > If I'm at a Unix-like shell, of course, there are plenty of
> options.
> > > >
> > > > In the lab, all you've got is notepad and calculator, so you
> might be
> > > > forced to copy the output from the terminal emulator, paste it
> into
> > > > notepad, and manually sort from there, line by line.
> > > >
> > > > Why do you want/need to do this?
> > > >
> > > > cheers,
> > > > Dale
> > > >
> > > >
> > > > Blogs and organic groups at http://www.ccie.net
> > > >
> > > >
> _______________________________________________________________________
> > > > Subscription information may be found at:
> > > > http://www.groupstudy.com/list/CCIELab.html
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> _________________________________________________________________
> > > Windows Live : Keep your life in sync.
> > >
> http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009
> > >
> > >
> > > Blogs and organic groups at http://www.ccie.net
> > >
> > >
> _______________________________________________________________________
> > > Subscription information may be found at:
> > > http://www.groupstudy.com/list/CCIELab.html
> >
> >
> > Blogs and organic groups at http://www.ccie.net
> >
> >
> _______________________________________________________________________
> > Subscription information may be found at:
> > http://www.groupstudy.com/list/CCIELab.html
>
>
> Blogs and organic groups at http://www.ccie.net
>
>
> _______________________________________________________________________
> Subscription information may be found at:
> http://www.groupstudy.com/list/CCIELab.html
>
>
> Blogs and organic groups at http://www.ccie.net
>
> _______________________________________________________________________
> Subscription information may be found at:
> http://www.groupstudy.com/list/CCIELab.html
Blogs and organic groups at http://www.ccie.net
_______________________________________________________________________
Subscription information may be found at:
http://www.groupstudy.com/list/CCIELab.html
Blogs and organic groups at http://www.ccie.net
Received on Sat Jun 06 2009 - 23:48:05 ART
This archive was generated by hypermail 2.2.0 : Wed Jul 01 2009 - 20:02:36 ART