Sorting blocks of data based on a particular row of data

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












I was given the below script by this great community to help sort the rows of information.




BEGIN




FS=":"

PROCINFO["sorted_in"]="@val_str_asc";




/./

values[$1]=$0




/^$/

asort(values)

for (element in values)

print values[element]

print ""

delete values




END




asort(values)

for (element in values)

print values[element]





Each block are sorted alphabetically, which is working as originally intended (shown below). Now I am asked to sort all these blocks of data (each block of data has a physical space between each other) based on the sessionStartTime. I think this is going to be alot harder since each 8-line block needs to stick together.




cabLoginID:0557CAWG0FP27K31JG7Q

loginName:john

memoryInfo:jsHeapSizeLimit:2181038080

session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
sessionStartTime:2018-10-18T13:03:00.973Z

totalJSHeapSize:36675584

usedJSHeapSize:29721040

userAgent:Mozilla/5.0



cabLoginID:05P4X6K6GFPJ7K31EJ7H

loginName:bob

memoryInfo:jsHeapSizeLimit:2181038080

session:cabSessionID:0536XLJPG7BJXRN42A0F
sessionStartTime:2018-10-11T11:37:28.195Z

totalJSHeapSize:54501376

usedJSHeapSize:35478968

userAgent:Mozilla/5.0



cabLoginID:053XCDTF8D4J6PD3BG8P

loginName:jack

memoryInfo:jsHeapSizeLimit:2217857988

session:cabSessionID:052FPBP6Q6X2XGERWHBT
sessionStartTime:2018-10-01T01:04:10.899Z

totalJSHeapSize:42358792

usedJSHeapSize:36482584

userAgent:Mozilla/5.0




Desired result:




cabLoginID:053XCDTF8D4J6PD3BG8P

loginName:jack

memoryInfo:jsHeapSizeLimit:2217857988

session:cabSessionID:052FPBP6Q6X2XGERWHBT
sessionStartTime:2018-10-01T01:04:10.899Z

totalJSHeapSize:42358792

usedJSHeapSize:36482584

userAgent:Mozilla/5.0



cabLoginID:05P4X6K6GFPJ7K31EJ7H

loginName:bob

memoryInfo:jsHeapSizeLimit:2181038080

session:cabSessionID:0536XLJPG7BJXRN42A0F
sessionStartTime:2018-10-11T11:37:28.195Z

totalJSHeapSize:54501376

usedJSHeapSize:35478968

userAgent:Mozilla/5.0



cabLoginID:0557CAWG0FP27K31JG7Q

loginName:john

memoryInfo:jsHeapSizeLimit:2181038080

session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
sessionStartTime:2018-10-18T13:03:00.973Z

totalJSHeapSize:36675584

usedJSHeapSize:29721040

userAgent:Mozilla/5.0







sort







share|improve this question







New contributor




Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.























    up vote
    0
    down vote

    favorite












    I was given the below script by this great community to help sort the rows of information.




    BEGIN




    FS=":"

    PROCINFO["sorted_in"]="@val_str_asc";




    /./

    values[$1]=$0




    /^$/

    asort(values)

    for (element in values)

    print values[element]

    print ""

    delete values




    END




    asort(values)

    for (element in values)

    print values[element]





    Each block are sorted alphabetically, which is working as originally intended (shown below). Now I am asked to sort all these blocks of data (each block of data has a physical space between each other) based on the sessionStartTime. I think this is going to be alot harder since each 8-line block needs to stick together.




    cabLoginID:0557CAWG0FP27K31JG7Q

    loginName:john

    memoryInfo:jsHeapSizeLimit:2181038080

    session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
    sessionStartTime:2018-10-18T13:03:00.973Z

    totalJSHeapSize:36675584

    usedJSHeapSize:29721040

    userAgent:Mozilla/5.0



    cabLoginID:05P4X6K6GFPJ7K31EJ7H

    loginName:bob

    memoryInfo:jsHeapSizeLimit:2181038080

    session:cabSessionID:0536XLJPG7BJXRN42A0F
    sessionStartTime:2018-10-11T11:37:28.195Z

    totalJSHeapSize:54501376

    usedJSHeapSize:35478968

    userAgent:Mozilla/5.0



    cabLoginID:053XCDTF8D4J6PD3BG8P

    loginName:jack

    memoryInfo:jsHeapSizeLimit:2217857988

    session:cabSessionID:052FPBP6Q6X2XGERWHBT
    sessionStartTime:2018-10-01T01:04:10.899Z

    totalJSHeapSize:42358792

    usedJSHeapSize:36482584

    userAgent:Mozilla/5.0




    Desired result:




    cabLoginID:053XCDTF8D4J6PD3BG8P

    loginName:jack

    memoryInfo:jsHeapSizeLimit:2217857988

    session:cabSessionID:052FPBP6Q6X2XGERWHBT
    sessionStartTime:2018-10-01T01:04:10.899Z

    totalJSHeapSize:42358792

    usedJSHeapSize:36482584

    userAgent:Mozilla/5.0



    cabLoginID:05P4X6K6GFPJ7K31EJ7H

    loginName:bob

    memoryInfo:jsHeapSizeLimit:2181038080

    session:cabSessionID:0536XLJPG7BJXRN42A0F
    sessionStartTime:2018-10-11T11:37:28.195Z

    totalJSHeapSize:54501376

    usedJSHeapSize:35478968

    userAgent:Mozilla/5.0



    cabLoginID:0557CAWG0FP27K31JG7Q

    loginName:john

    memoryInfo:jsHeapSizeLimit:2181038080

    session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
    sessionStartTime:2018-10-18T13:03:00.973Z

    totalJSHeapSize:36675584

    usedJSHeapSize:29721040

    userAgent:Mozilla/5.0







    sort







    share|improve this question







    New contributor




    Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.





















      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I was given the below script by this great community to help sort the rows of information.




      BEGIN




      FS=":"

      PROCINFO["sorted_in"]="@val_str_asc";




      /./

      values[$1]=$0




      /^$/

      asort(values)

      for (element in values)

      print values[element]

      print ""

      delete values




      END




      asort(values)

      for (element in values)

      print values[element]





      Each block are sorted alphabetically, which is working as originally intended (shown below). Now I am asked to sort all these blocks of data (each block of data has a physical space between each other) based on the sessionStartTime. I think this is going to be alot harder since each 8-line block needs to stick together.




      cabLoginID:0557CAWG0FP27K31JG7Q

      loginName:john

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
      sessionStartTime:2018-10-18T13:03:00.973Z

      totalJSHeapSize:36675584

      usedJSHeapSize:29721040

      userAgent:Mozilla/5.0



      cabLoginID:05P4X6K6GFPJ7K31EJ7H

      loginName:bob

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:0536XLJPG7BJXRN42A0F
      sessionStartTime:2018-10-11T11:37:28.195Z

      totalJSHeapSize:54501376

      usedJSHeapSize:35478968

      userAgent:Mozilla/5.0



      cabLoginID:053XCDTF8D4J6PD3BG8P

      loginName:jack

      memoryInfo:jsHeapSizeLimit:2217857988

      session:cabSessionID:052FPBP6Q6X2XGERWHBT
      sessionStartTime:2018-10-01T01:04:10.899Z

      totalJSHeapSize:42358792

      usedJSHeapSize:36482584

      userAgent:Mozilla/5.0




      Desired result:




      cabLoginID:053XCDTF8D4J6PD3BG8P

      loginName:jack

      memoryInfo:jsHeapSizeLimit:2217857988

      session:cabSessionID:052FPBP6Q6X2XGERWHBT
      sessionStartTime:2018-10-01T01:04:10.899Z

      totalJSHeapSize:42358792

      usedJSHeapSize:36482584

      userAgent:Mozilla/5.0



      cabLoginID:05P4X6K6GFPJ7K31EJ7H

      loginName:bob

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:0536XLJPG7BJXRN42A0F
      sessionStartTime:2018-10-11T11:37:28.195Z

      totalJSHeapSize:54501376

      usedJSHeapSize:35478968

      userAgent:Mozilla/5.0



      cabLoginID:0557CAWG0FP27K31JG7Q

      loginName:john

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
      sessionStartTime:2018-10-18T13:03:00.973Z

      totalJSHeapSize:36675584

      usedJSHeapSize:29721040

      userAgent:Mozilla/5.0







      sort







      share|improve this question







      New contributor




      Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      I was given the below script by this great community to help sort the rows of information.




      BEGIN




      FS=":"

      PROCINFO["sorted_in"]="@val_str_asc";




      /./

      values[$1]=$0




      /^$/

      asort(values)

      for (element in values)

      print values[element]

      print ""

      delete values




      END




      asort(values)

      for (element in values)

      print values[element]





      Each block are sorted alphabetically, which is working as originally intended (shown below). Now I am asked to sort all these blocks of data (each block of data has a physical space between each other) based on the sessionStartTime. I think this is going to be alot harder since each 8-line block needs to stick together.




      cabLoginID:0557CAWG0FP27K31JG7Q

      loginName:john

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
      sessionStartTime:2018-10-18T13:03:00.973Z

      totalJSHeapSize:36675584

      usedJSHeapSize:29721040

      userAgent:Mozilla/5.0



      cabLoginID:05P4X6K6GFPJ7K31EJ7H

      loginName:bob

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:0536XLJPG7BJXRN42A0F
      sessionStartTime:2018-10-11T11:37:28.195Z

      totalJSHeapSize:54501376

      usedJSHeapSize:35478968

      userAgent:Mozilla/5.0



      cabLoginID:053XCDTF8D4J6PD3BG8P

      loginName:jack

      memoryInfo:jsHeapSizeLimit:2217857988

      session:cabSessionID:052FPBP6Q6X2XGERWHBT
      sessionStartTime:2018-10-01T01:04:10.899Z

      totalJSHeapSize:42358792

      usedJSHeapSize:36482584

      userAgent:Mozilla/5.0




      Desired result:




      cabLoginID:053XCDTF8D4J6PD3BG8P

      loginName:jack

      memoryInfo:jsHeapSizeLimit:2217857988

      session:cabSessionID:052FPBP6Q6X2XGERWHBT
      sessionStartTime:2018-10-01T01:04:10.899Z

      totalJSHeapSize:42358792

      usedJSHeapSize:36482584

      userAgent:Mozilla/5.0



      cabLoginID:05P4X6K6GFPJ7K31EJ7H

      loginName:bob

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:0536XLJPG7BJXRN42A0F
      sessionStartTime:2018-10-11T11:37:28.195Z

      totalJSHeapSize:54501376

      usedJSHeapSize:35478968

      userAgent:Mozilla/5.0



      cabLoginID:0557CAWG0FP27K31JG7Q

      loginName:john

      memoryInfo:jsHeapSizeLimit:2181038080

      session:cabSessionID:05P2R3PJGKG2Y2XE4NCZ
      sessionStartTime:2018-10-18T13:03:00.973Z

      totalJSHeapSize:36675584

      usedJSHeapSize:29721040

      userAgent:Mozilla/5.0







      sort




      sort






      share|improve this question







      New contributor




      Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 20 mins ago









      Kam

      63




      63




      New contributor




      Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Kam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.

























          active

          oldest

          votes











          Your Answer







          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "106"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: false,
          noModals: false,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );






          Kam is a new contributor. Be nice, and check out our Code of Conduct.









           

          draft saved


          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f477807%2fsorting-blocks-of-data-based-on-a-particular-row-of-data%23new-answer', 'question_page');

          );

          Post as a guest






















          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Kam is a new contributor. Be nice, and check out our Code of Conduct.









           

          draft saved


          draft discarded


















          Kam is a new contributor. Be nice, and check out our Code of Conduct.












          Kam is a new contributor. Be nice, and check out our Code of Conduct.











          Kam is a new contributor. Be nice, and check out our Code of Conduct.













           


          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f477807%2fsorting-blocks-of-data-based-on-a-particular-row-of-data%23new-answer', 'question_page');

          );

          Post as a guest
































































          -

          Popular posts from this blog

          Peggy Mitchell

          Image
          EastEnders character This article is about the soap opera character. For the British tennis player, see Peggy Michell. For the author, see Margaret Mitchell. Peggy Mitchell Barbara Windsor as Peggy Mitchell (2008) EastEnders character Portrayed by Jo Warne (1991) Barbara Windsor (1994–2016) Duration 1991, 1994–2010, 2013–2016 First appearance Episode 650 30 April 1991  ( 1991-04-30 ) Last appearance Episode 5286 17 May 2016  ( 2016-05-17 ) (appearance) Episode 5287 19 May 2016 (voiceover) Introduced by Michael Ferguson (1991) Barbara Emile (1994) Louise Berridge (2004) Kate Harwood (2005) Lorraine Newman (2013) Dominic Treadwell-Collins (2014) Spin-off appearances The Mitchells - Naked Truths (1998) Classification Former; regular Profile Other names Peggy Butcher Occupation Barmaid Businesswoman Pub landlady Jo Warne as Peggy Mitchell (1991) Family Family Mitchell Father Jack Martin Mother Lily Martin Sisters Aunt ...
          Read more

          The Forum (Inglewood, California)

          Image
          The Forum "LA Forum" Prairie Ave. façade of The Forum in 2014 Full name The Forum, presented by Chase Former names The Forum (1967–1988) Great Western Forum (1988–2003) Address 3900 W. Manchester Blvd Location Inglewood, California Coordinates Coordinates: 33°57′29″N 118°20′31″W  /  33.95806°N 118.34194°W  / 33.95806; -118.34194 Public transit     Downtown Inglewood station Owner The Madison Square Garden Company Operator MSG Entertainment Seating type Reserved Capacity 17,500 Half-bowl: 8,000 Construction Broke ground July 1, 1966  ( 1966-07-01 ) Opened December 30, 1967  ( 1967-12-30 ) Renovated 1988, 2012–2014 Construction cost $16 million Renovation: 2014: $76.5 million Architect Charles Luckman Associates (original) Brisbin Brook Beynon (renovation) Structural engineer Johnson & Nielsen Associates (original) Severud Associates (renovation) Genera...
          Read more

          Palaiologos

          Image
          Palaiologos Παλαιολόγος Palaeologus, Palaeologue Imperial Family Double-headed eagle with the family cypher Country Byzantine Empire, Duchy of Montferrat (remaining lineage after Empire annexed by Ottomans) Founded 11th century  ( 11th century ) Founder Nikephoros Palaiologos (first known) Final ruler Constantine XI Palaiologos (Byzantine Empire) Margaret Paleologa (Montferrat) Titles Byzantine Emperor Marquess of Montferrat Style(s) "Augustus" "Basileus" "Autokrator" Traditions Greek Orthodoxy (predominantly) Roman Catholicism (remaining lineage in Montferrat) Dissolution 1533  ( 1533 ) Cadet branches Claimants: House of Kastrioti (defunct) House of Rurik (defunct) Palaiologan dynasty Chronology Michael VIII 1259–1282 with Andronikos II as co-emperor, 1261–1282 Andronikos II 1282–1328 with Michael IX (1294–1320) and Andronikos III (1321–1328) as co-emperors Andronikos III 1328–1341 John...
          Read more