Re: a two-level 'sort' question

From: Barry Margolin (barmar_at_alum.mit.edu)
Date: 03/26/05

  • Next message: Bill Seivert: "Re: a two-level 'sort' question" 
    Date: Fri, 25 Mar 2005 20:53:47 -0500

    In article <1111785861.926694.303320@l41g2000cwc.googlegroups.com>,
     subPlanck@excite.com wrote:

    > I'm stuck trying to sort a long list of files in the form:
    >
    > Feb 24 13:50 060399_20a08.124
    > Feb 22 12:06 060399_20a09.035
    > Feb 22 12:06 060399_20a09.034
    >
    > whereby the entries are first sorted/grouped by
    > sort -t_ -d -k 2.1,2.5
    > and each block is sorted in an ascending order by date.
    >
    > man sort gives the following example to sort
    > 30 December
    > 23 MAY
    > 25 June
    > 10 June
    > sort -k 2M -k 1n
    > but I want to keep sorted blocks after the undersore as priority
    > blocks.
    >
    > The way I see it, the problem is in having to switch filed separators,
    > an underscore and space, in the same sort expresasion. Can it be done?
    >
    > I'd appreciate any suggestions, because none of my attempts have been
    > successful.

    Use -k 1.1,1,12 to specify the second field to be just the 12 characters
    containing the date and time. 

    -- 
Barry Margolin, barmar@alum.mit.edu
Arlington, MA
*** PLEASE post questions in newsgroups, not directly to me ***
  • Next message: Bill Seivert: "Re: a two-level 'sort' question"

    Relevant Pages

    • Re: automatic sort
      ... Assume the text entries are in the range A1:A20. ... sorted in ascending order, enter this formula as an array with the key combo ... To sort in descending order, in the formula change SMALL to LARGE. ...
      (microsoft.public.excel.worksheet.functions)
    • a two-level sort question
      ... I'm stuck trying to sort a long list of files in the form: ... whereby the entries are first sorted/grouped by ... but I want to keep sorted blocks after the undersore as priority ...
      (comp.unix.questions)
    • Re: a two-level sort question
      ... Barry Margolin wrote: ... >>and each block is sorted in an ascending order by date. ... >>man sort gives the following example to sort ... >>but I want to keep sorted blocks after the undersore as priority ...
      (comp.unix.questions)
    • Re: Fantasy Books not set in pseudo-Europe
      ... looking for this sort of thing and haven't read those, ... you have to go to the entries on the 1001 Nights and on "Persia" ... <Wheel of the Infinite> ... Fantasy rooted in no particular Earth historical culture is not, ...
      (rec.arts.sf.written)
    • How to sort the variable length objects in Lexicographical order?
      ... I am involved in the Agent development for providing the support for ... about the lexicographic ordering of the table entries with respect to ... Because we need to sort the connection table based on four parameters ...
      (comp.protocols.snmp)