Moving the last six digits to the beginning of numbers

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











up vote
1
down vote

favorite












I am using Twitter to pull news into an email, and the last six fields are the date and time. I would like these to be the first six fields. What's the command in awk to move the last n fields to the start of the line?



I have tried googling it but all the examples given assume each line has the same number of fields



example:



76356378090986
08976357627980089
089723571237809209
0897253712730912838798
908916523568909887
876756467890
09876535467890
765643324343
467890876543
234567890987654
123456789009876543
54323456789876
09876543345678
123456789009876
12345678998765


result:



09098676356378
98008908976357627
809209089723571237
8387980897253712730912
909887908916523568
467890876756
46789009876535
324343765643
876543467890
987654234567890
876543123456789009
78987654323456
34567809876543
009876123456789
99876512345678





text-processing awk







share|improve this question









New contributor




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























    up vote
    1
    down vote

    favorite












    I am using Twitter to pull news into an email, and the last six fields are the date and time. I would like these to be the first six fields. What's the command in awk to move the last n fields to the start of the line?



    I have tried googling it but all the examples given assume each line has the same number of fields



    example:



    76356378090986
    08976357627980089
    089723571237809209
    0897253712730912838798
    908916523568909887
    876756467890
    09876535467890
    765643324343
    467890876543
    234567890987654
    123456789009876543
    54323456789876
    09876543345678
    123456789009876
    12345678998765


    result:



    09098676356378
    98008908976357627
    809209089723571237
    8387980897253712730912
    909887908916523568
    467890876756
    46789009876535
    324343765643
    876543467890
    987654234567890
    876543123456789009
    78987654323456
    34567809876543
    009876123456789
    99876512345678





    text-processing awk







    share|improve this question









    New contributor




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





















      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I am using Twitter to pull news into an email, and the last six fields are the date and time. I would like these to be the first six fields. What's the command in awk to move the last n fields to the start of the line?



      I have tried googling it but all the examples given assume each line has the same number of fields



      example:



      76356378090986
      08976357627980089
      089723571237809209
      0897253712730912838798
      908916523568909887
      876756467890
      09876535467890
      765643324343
      467890876543
      234567890987654
      123456789009876543
      54323456789876
      09876543345678
      123456789009876
      12345678998765


      result:



      09098676356378
      98008908976357627
      809209089723571237
      8387980897253712730912
      909887908916523568
      467890876756
      46789009876535
      324343765643
      876543467890
      987654234567890
      876543123456789009
      78987654323456
      34567809876543
      009876123456789
      99876512345678





      text-processing awk







      share|improve this question









      New contributor




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











      I am using Twitter to pull news into an email, and the last six fields are the date and time. I would like these to be the first six fields. What's the command in awk to move the last n fields to the start of the line?



      I have tried googling it but all the examples given assume each line has the same number of fields



      example:



      76356378090986
      08976357627980089
      089723571237809209
      0897253712730912838798
      908916523568909887
      876756467890
      09876535467890
      765643324343
      467890876543
      234567890987654
      123456789009876543
      54323456789876
      09876543345678
      123456789009876
      12345678998765


      result:



      09098676356378
      98008908976357627
      809209089723571237
      8387980897253712730912
      909887908916523568
      467890876756
      46789009876535
      324343765643
      876543467890
      987654234567890
      876543123456789009
      78987654323456
      34567809876543
      009876123456789
      99876512345678





      text-processing awk




      text-processing awk






      share|improve this question









      New contributor




      marco 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




      marco 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








      edited 13 mins ago









      Rui F Ribeiro

      37k1273117




      37k1273117






      New contributor




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









      asked 27 mins ago









      marco

      1204




      1204




      New contributor




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





      New contributor





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






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




















          3 Answers
          3






          active

          oldest

          votes

















          up vote
          3
          down vote













          With sed:



          sed 's/(.*)(.6)/21/'





          share|improve this answer




















          • sooooooo elegant ;-)
            – Goro
            18 mins ago

















          up vote
          1
          down vote













          cat file | sed -e 's/(.)/1 /g' | awk ' for (i = 1; i <= NF; i++) printf "%s" FS, $((NF-7+i) % NF+1); print ""' | sed 's/ //g'
          09098676356378
          98008908976357627
          809209089723571237
          8387980897253712730912
          909887908916523568
          467890876756
          46789009876535
          324343765643
          876543467890
          987654234567890
          876543123456789009
          78987654323456
          34567809876543
          009876123456789
          99876512345678





          share|improve this answer




















          • that's a clear example of [Humor] Useless use of cat. sed is able to read a file. Having used awk, why also call sed (twice)?
            – Isaac
            2 mins ago










          • @Isaac thank you for sharing. It is the idea, the first sed created spaces between digits and the last sed removed them , it is an idea and still valied regardless if whether it is reckless or not ;-)
            – Goro
            43 secs ago


















          up vote
          0
          down vote













          With sed:



          sed 's/(.*)(.6)/21/'


          Or:



          sed -E 's/(.*)(.6)/21/'



          With (GNU) awk:



          awk 'print gensub(/(.*)(.6)/,"21",1)'





          share




















            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
            );



            );






            marco 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%2f473964%2fmoving-the-last-six-digits-to-the-beginning-of-numbers%23new-answer', 'question_page');

            );

            Post as a guest

















            3 Answers
            3






            active

            oldest

            votes








            3 Answers
            3






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            3
            down vote













            With sed:



            sed 's/(.*)(.6)/21/'





            share|improve this answer




















            • sooooooo elegant ;-)
              – Goro
              18 mins ago














            up vote
            3
            down vote













            With sed:



            sed 's/(.*)(.6)/21/'





            share|improve this answer




















            • sooooooo elegant ;-)
              – Goro
              18 mins ago












            up vote
            3
            down vote










            up vote
            3
            down vote









            With sed:



            sed 's/(.*)(.6)/21/'





            share|improve this answer












            With sed:



            sed 's/(.*)(.6)/21/'






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered 19 mins ago









            Stéphane Chazelas

            287k53531868




            287k53531868











            • sooooooo elegant ;-)
              – Goro
              18 mins ago
















            • sooooooo elegant ;-)
              – Goro
              18 mins ago















            sooooooo elegant ;-)
            – Goro
            18 mins ago




            sooooooo elegant ;-)
            – Goro
            18 mins ago












            up vote
            1
            down vote













            cat file | sed -e 's/(.)/1 /g' | awk ' for (i = 1; i <= NF; i++) printf "%s" FS, $((NF-7+i) % NF+1); print ""' | sed 's/ //g'
            09098676356378
            98008908976357627
            809209089723571237
            8387980897253712730912
            909887908916523568
            467890876756
            46789009876535
            324343765643
            876543467890
            987654234567890
            876543123456789009
            78987654323456
            34567809876543
            009876123456789
            99876512345678





            share|improve this answer




















            • that's a clear example of [Humor] Useless use of cat. sed is able to read a file. Having used awk, why also call sed (twice)?
              – Isaac
              2 mins ago










            • @Isaac thank you for sharing. It is the idea, the first sed created spaces between digits and the last sed removed them , it is an idea and still valied regardless if whether it is reckless or not ;-)
              – Goro
              43 secs ago















            up vote
            1
            down vote













            cat file | sed -e 's/(.)/1 /g' | awk ' for (i = 1; i <= NF; i++) printf "%s" FS, $((NF-7+i) % NF+1); print ""' | sed 's/ //g'
            09098676356378
            98008908976357627
            809209089723571237
            8387980897253712730912
            909887908916523568
            467890876756
            46789009876535
            324343765643
            876543467890
            987654234567890
            876543123456789009
            78987654323456
            34567809876543
            009876123456789
            99876512345678





            share|improve this answer




















            • that's a clear example of [Humor] Useless use of cat. sed is able to read a file. Having used awk, why also call sed (twice)?
              – Isaac
              2 mins ago










            • @Isaac thank you for sharing. It is the idea, the first sed created spaces between digits and the last sed removed them , it is an idea and still valied regardless if whether it is reckless or not ;-)
              – Goro
              43 secs ago













            up vote
            1
            down vote










            up vote
            1
            down vote









            cat file | sed -e 's/(.)/1 /g' | awk ' for (i = 1; i <= NF; i++) printf "%s" FS, $((NF-7+i) % NF+1); print ""' | sed 's/ //g'
            09098676356378
            98008908976357627
            809209089723571237
            8387980897253712730912
            909887908916523568
            467890876756
            46789009876535
            324343765643
            876543467890
            987654234567890
            876543123456789009
            78987654323456
            34567809876543
            009876123456789
            99876512345678





            share|improve this answer












            cat file | sed -e 's/(.)/1 /g' | awk ' for (i = 1; i <= NF; i++) printf "%s" FS, $((NF-7+i) % NF+1); print ""' | sed 's/ //g'
            09098676356378
            98008908976357627
            809209089723571237
            8387980897253712730912
            909887908916523568
            467890876756
            46789009876535
            324343765643
            876543467890
            987654234567890
            876543123456789009
            78987654323456
            34567809876543
            009876123456789
            99876512345678






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered 19 mins ago









            Goro

            7,45253169




            7,45253169











            • that's a clear example of [Humor] Useless use of cat. sed is able to read a file. Having used awk, why also call sed (twice)?
              – Isaac
              2 mins ago










            • @Isaac thank you for sharing. It is the idea, the first sed created spaces between digits and the last sed removed them , it is an idea and still valied regardless if whether it is reckless or not ;-)
              – Goro
              43 secs ago

















            • that's a clear example of [Humor] Useless use of cat. sed is able to read a file. Having used awk, why also call sed (twice)?
              – Isaac
              2 mins ago










            • @Isaac thank you for sharing. It is the idea, the first sed created spaces between digits and the last sed removed them , it is an idea and still valied regardless if whether it is reckless or not ;-)
              – Goro
              43 secs ago
















            that's a clear example of [Humor] Useless use of cat. sed is able to read a file. Having used awk, why also call sed (twice)?
            – Isaac
            2 mins ago




            that's a clear example of [Humor] Useless use of cat. sed is able to read a file. Having used awk, why also call sed (twice)?
            – Isaac
            2 mins ago












            @Isaac thank you for sharing. It is the idea, the first sed created spaces between digits and the last sed removed them , it is an idea and still valied regardless if whether it is reckless or not ;-)
            – Goro
            43 secs ago





            @Isaac thank you for sharing. It is the idea, the first sed created spaces between digits and the last sed removed them , it is an idea and still valied regardless if whether it is reckless or not ;-)
            – Goro
            43 secs ago











            up vote
            0
            down vote













            With sed:



            sed 's/(.*)(.6)/21/'


            Or:



            sed -E 's/(.*)(.6)/21/'



            With (GNU) awk:



            awk 'print gensub(/(.*)(.6)/,"21",1)'





            share
























              up vote
              0
              down vote













              With sed:



              sed 's/(.*)(.6)/21/'


              Or:



              sed -E 's/(.*)(.6)/21/'



              With (GNU) awk:



              awk 'print gensub(/(.*)(.6)/,"21",1)'





              share






















                up vote
                0
                down vote










                up vote
                0
                down vote









                With sed:



                sed 's/(.*)(.6)/21/'


                Or:



                sed -E 's/(.*)(.6)/21/'



                With (GNU) awk:



                awk 'print gensub(/(.*)(.6)/,"21",1)'





                share












                With sed:



                sed 's/(.*)(.6)/21/'


                Or:



                sed -E 's/(.*)(.6)/21/'



                With (GNU) awk:



                awk 'print gensub(/(.*)(.6)/,"21",1)'






                share











                share


                share










                answered 6 mins ago









                Isaac

                7,73711137




                7,73711137




















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









                     

                    draft saved


                    draft discarded


















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












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











                    marco 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%2f473964%2fmoving-the-last-six-digits-to-the-beginning-of-numbers%23new-answer', 'question_page');

                    );

                    Post as a guest
































































                    Comments

                    Post a Comment

                    Popular posts from this blog

                    What does second last employer means? [closed]

                    Image
                    Clash Royale CLAN TAG #URR8PPP .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0; up vote -3 down vote favorite Say, for example I have worked in the following companies, Company A => 2010 - 2011 Company B => 2011 - 2012 Company C => 2012 - Till Date Company D => Have offer Now assume Company D is asking to submit documents from my second last employer. So from the list of companies given, which company would be qualified as second last employer? software-industry employer share | improve this question asked Aug 10 '14 at 5:16 Rajaprabhu Aravindasamy 559 1 6 13 closed as off-topic by Jim G., jmort253 ♦ Aug 11 '14 at 1:58 This question appears to be off-topic. The users who voted to close gave this specific reason: "Questions seeking advice on company-specific regulations, agreements, or policies should be directed to your manager or HR department. Questions that address...
                    Read more

                    List of Gilmore Girls characters

                    Image
                    The season three cast—(Back row): Lane, Michel, Paris, Emily, Richard, Sookie, Miss Patty, Kirk; Front row: Jess, Luke, Lorelai, Rory, Dean This is a list of characters for the comedy-drama television series Gilmore Girls . Contents 1 Main characters 1.1 Lorelai Gilmore 1.2 Rory Gilmore 1.3 Sookie St. James 1.4 Lane Kim 1.5 Michel Gerard 1.6 Luke Danes 1.7 Emily Gilmore 1.8 Richard Gilmore 1.9 Paris Geller 1.10 Dean Forester 1.11 Jess Mariano 1.12 Kirk Gleason 1.13 Jason Stiles 1.14 Logan Huntzberger 2 Major recurring characters 2.1 Christopher Hayden 2.2 Jackson Belleville 2.3 Mrs. Kim 2.4 Tristin DuGray 2.5 Max Medina 2.6 Taylor Doose 2.7 Dave Rygalski 2.8 Marty 3 Recurring characters 3.1 Stars Hollow 3.2 Chilton 3.3 Yale 3.4 Other 4 Notable guest stars 5 Unseen characters 6 Notes 7 References Main characters Actor Character Appearances Season 1 Season 2 Season 3 Season 4 Season 5 Season 6 Season 7 A Year in the Life Lauren Graham Lorelai Gilmore...
                    Read more

                    Confectionery

                    Image
                    Prepared foods made with a lot of sugar or other cabohydrates "Sweetmeat" redirects here. For the racehorse, see Sweetmeat (horse). Not to be confused with Sweetbread. This Kransekake is a traditional Scandinavian baker's confection. Confectionery is the art of making confections , which are food items that are rich in sugar and carbohydrates. Exact definitions are difficult. [1] In general, though, confectionery is divided into two broad and somewhat overlapping categories, bakers' confections and sugar confections. [2] Bakers' confectionery, also called flour confections , includes principally sweet pastries, cakes, and similar baked goods. Sugar confectionery includes candies ( sweets in British English), candied nuts, chocolates, chewing gum, bubble gum, pastillage, and other confections that are made primarily of sugar. In some cases, chocolate confections (confections made of chocolate) are treated as a separate category, as are sugar-free versions of ...
                    Read more