print a column with the desire format output












1














I have a list of the following data in a file:



    -0.3476890000000000
0.0743938333333333
-1.0990240000000000
0.0743938333333333
-0.2169100000000000
0.0879397500000000


and I am trying to align all data so to have:



    -0.347689000000000
0.0743938333333333
-1.099024000000000
0.0743938333333333
-0.216910000000000
0.0879397500000000


unfortunately I couldn't make it with awk '{printf "%18sn", $1}'. The ideal is to have an output like this:



   -0.3476890000000000
0.0743938333333333
-1.0990240000000000
0.0743938333333333
-0.2169100000000000
0.0879397500000000









share|improve this question





























    1














    I have a list of the following data in a file:



        -0.3476890000000000
    0.0743938333333333
    -1.0990240000000000
    0.0743938333333333
    -0.2169100000000000
    0.0879397500000000


    and I am trying to align all data so to have:



        -0.347689000000000
    0.0743938333333333
    -1.099024000000000
    0.0743938333333333
    -0.216910000000000
    0.0879397500000000


    unfortunately I couldn't make it with awk '{printf "%18sn", $1}'. The ideal is to have an output like this:



       -0.3476890000000000
    0.0743938333333333
    -1.0990240000000000
    0.0743938333333333
    -0.2169100000000000
    0.0879397500000000









    share|improve this question



























      1












      1








      1







      I have a list of the following data in a file:



          -0.3476890000000000
      0.0743938333333333
      -1.0990240000000000
      0.0743938333333333
      -0.2169100000000000
      0.0879397500000000


      and I am trying to align all data so to have:



          -0.347689000000000
      0.0743938333333333
      -1.099024000000000
      0.0743938333333333
      -0.216910000000000
      0.0879397500000000


      unfortunately I couldn't make it with awk '{printf "%18sn", $1}'. The ideal is to have an output like this:



         -0.3476890000000000
      0.0743938333333333
      -1.0990240000000000
      0.0743938333333333
      -0.2169100000000000
      0.0879397500000000









      share|improve this question















      I have a list of the following data in a file:



          -0.3476890000000000
      0.0743938333333333
      -1.0990240000000000
      0.0743938333333333
      -0.2169100000000000
      0.0879397500000000


      and I am trying to align all data so to have:



          -0.347689000000000
      0.0743938333333333
      -1.099024000000000
      0.0743938333333333
      -0.216910000000000
      0.0879397500000000


      unfortunately I couldn't make it with awk '{printf "%18sn", $1}'. The ideal is to have an output like this:



         -0.3476890000000000
      0.0743938333333333
      -1.0990240000000000
      0.0743938333333333
      -0.2169100000000000
      0.0879397500000000






      bash awk printf






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 46 mins ago









      GAD3R

      25.3k1749106




      25.3k1749106










      asked 1 hour ago









      Dimitris Mintis

      575




      575






















          2 Answers
          2






          active

          oldest

          votes


















          3














          Maybe too small a field width. Try



          awk '{printf "%19sn", $1}' file
          -0.3476890000000000
          0.0743938333333333
          -1.0990240000000000
          0.0743938333333333
          -0.2169100000000000
          0.0879397500000000





          share|improve this answer





























            1














            Both GNU Awk (gawk) and mawk appear to support the C printf ' ' modifier that adds a space in front of positive numbers to align them with negative ones




               ' '    (a  space)  A  blank should be left before a positive number (or
            empty string) produced by a signed conversion.



            So for example:



            $ mawk '{printf "% 22.16fn", $1}' file
            -0.3476890000000000
            0.0743938333333333
            -1.0990240000000000
            0.0743938333333333
            -0.2169100000000000
            0.0879397500000000


            Alternatively, with numfmt



            $ numfmt --format='% 22.16f' < file
            -0.3476890000000000
            0.0743938333333333
            -1.0990240000000000
            0.0743938333333333
            -0.2169100000000000
            0.0879397500000000





            share|improve this answer





















              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',
              autoActivateHeartbeat: false,
              convertImagesToLinks: false,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: null,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              });


              }
              });














              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f490628%2fprint-a-column-with-the-desire-format-output%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              3














              Maybe too small a field width. Try



              awk '{printf "%19sn", $1}' file
              -0.3476890000000000
              0.0743938333333333
              -1.0990240000000000
              0.0743938333333333
              -0.2169100000000000
              0.0879397500000000





              share|improve this answer


























                3














                Maybe too small a field width. Try



                awk '{printf "%19sn", $1}' file
                -0.3476890000000000
                0.0743938333333333
                -1.0990240000000000
                0.0743938333333333
                -0.2169100000000000
                0.0879397500000000





                share|improve this answer
























                  3












                  3








                  3






                  Maybe too small a field width. Try



                  awk '{printf "%19sn", $1}' file
                  -0.3476890000000000
                  0.0743938333333333
                  -1.0990240000000000
                  0.0743938333333333
                  -0.2169100000000000
                  0.0879397500000000





                  share|improve this answer












                  Maybe too small a field width. Try



                  awk '{printf "%19sn", $1}' file
                  -0.3476890000000000
                  0.0743938333333333
                  -1.0990240000000000
                  0.0743938333333333
                  -0.2169100000000000
                  0.0879397500000000






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 1 hour ago









                  RudiC

                  4,0691312




                  4,0691312

























                      1














                      Both GNU Awk (gawk) and mawk appear to support the C printf ' ' modifier that adds a space in front of positive numbers to align them with negative ones




                         ' '    (a  space)  A  blank should be left before a positive number (or
                      empty string) produced by a signed conversion.



                      So for example:



                      $ mawk '{printf "% 22.16fn", $1}' file
                      -0.3476890000000000
                      0.0743938333333333
                      -1.0990240000000000
                      0.0743938333333333
                      -0.2169100000000000
                      0.0879397500000000


                      Alternatively, with numfmt



                      $ numfmt --format='% 22.16f' < file
                      -0.3476890000000000
                      0.0743938333333333
                      -1.0990240000000000
                      0.0743938333333333
                      -0.2169100000000000
                      0.0879397500000000





                      share|improve this answer


























                        1














                        Both GNU Awk (gawk) and mawk appear to support the C printf ' ' modifier that adds a space in front of positive numbers to align them with negative ones




                           ' '    (a  space)  A  blank should be left before a positive number (or
                        empty string) produced by a signed conversion.



                        So for example:



                        $ mawk '{printf "% 22.16fn", $1}' file
                        -0.3476890000000000
                        0.0743938333333333
                        -1.0990240000000000
                        0.0743938333333333
                        -0.2169100000000000
                        0.0879397500000000


                        Alternatively, with numfmt



                        $ numfmt --format='% 22.16f' < file
                        -0.3476890000000000
                        0.0743938333333333
                        -1.0990240000000000
                        0.0743938333333333
                        -0.2169100000000000
                        0.0879397500000000





                        share|improve this answer
























                          1












                          1








                          1






                          Both GNU Awk (gawk) and mawk appear to support the C printf ' ' modifier that adds a space in front of positive numbers to align them with negative ones




                             ' '    (a  space)  A  blank should be left before a positive number (or
                          empty string) produced by a signed conversion.



                          So for example:



                          $ mawk '{printf "% 22.16fn", $1}' file
                          -0.3476890000000000
                          0.0743938333333333
                          -1.0990240000000000
                          0.0743938333333333
                          -0.2169100000000000
                          0.0879397500000000


                          Alternatively, with numfmt



                          $ numfmt --format='% 22.16f' < file
                          -0.3476890000000000
                          0.0743938333333333
                          -1.0990240000000000
                          0.0743938333333333
                          -0.2169100000000000
                          0.0879397500000000





                          share|improve this answer












                          Both GNU Awk (gawk) and mawk appear to support the C printf ' ' modifier that adds a space in front of positive numbers to align them with negative ones




                             ' '    (a  space)  A  blank should be left before a positive number (or
                          empty string) produced by a signed conversion.



                          So for example:



                          $ mawk '{printf "% 22.16fn", $1}' file
                          -0.3476890000000000
                          0.0743938333333333
                          -1.0990240000000000
                          0.0743938333333333
                          -0.2169100000000000
                          0.0879397500000000


                          Alternatively, with numfmt



                          $ numfmt --format='% 22.16f' < file
                          -0.3476890000000000
                          0.0743938333333333
                          -1.0990240000000000
                          0.0743938333333333
                          -0.2169100000000000
                          0.0879397500000000






                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered 28 mins ago









                          steeldriver

                          34.2k35083




                          34.2k35083






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Unix & Linux Stack Exchange!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.





                              Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                              Please pay close attention to the following guidance:


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f490628%2fprint-a-column-with-the-desire-format-output%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown