Re: Sorting routes -- was --> Re:

Yeah... man this is way OT for group study.... sorry people.

I usually skip the "character deliminated" field seperation on an import in
excel and drag my own colomns. Then copy and paste 4 different colomns back
into notepad, which lines right back up into one line and start from there.
If you're a windows nerd, halla! lol.
My microsoft mouse kills your regex! :P

Chris

On Sat, Jun 6, 2009 at 11:48 PM, Kelly <kelly_at_cliffhanger.com> wrote:

>
> 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:57:55 ART