How to delete columns with zero value in each line? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) 2019 Community Moderator Election Results Why I closed the “Why is Kali so hard” questionHow to remove a column or multiple columns from file using shell command?Cost-efficiently pair each line of a file with all othersarithmetic operation with columns in text fileHow can I replace rows containing ONLY number ' 0' with blank rows using AWK?How to selectively remove columns and rows with bash?Delete columns that sum to zeroHow to add commas (based on count in a line, igonoring the comma in the double quote text) at the end of each line?How to insert comma at given location?How to treat a string of a file as a value when run awk?How to read a file line by line then take each line and insert into txt file

Why did the Falcon Heavy center core fall off the ASDS OCISLY barge?

List *all* the tuples!

String `!23` is replaced with `docker` in command line

Do I really need recursive chmod to restrict access to a folder?

Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?

Book where humans were engineered with genes from animal species to survive hostile planets

How widely used is the term Treppenwitz? Is it something that most Germans know?

Can inflation occur in a positive-sum game currency system such as the Stack Exchange reputation system?

What are the pros and cons of Aerospike nosecones?

Extract all GPU name, model and GPU ram

How to tell that you are a giant?

Identifying polygons that intersect with another layer using QGIS?

What does this icon in iOS Stardew Valley mean?

What is the role of the transistor and diode in a soft start circuit?

If a contract sometimes uses the wrong name, is it still valid?

Output the ŋarâþ crîþ alphabet song without using (m)any letters

Why did the IBM 650 use bi-quinary?

Is it true that "carbohydrates are of no use for the basal metabolic need"?

List of Python versions

How to bypass password on Windows XP account?

At the end of Thor: Ragnarok why don't the Asgardians turn and head for the Bifrost as per their original plan?

Can a non-EU citizen traveling with me come with me through the EU passport line?

Using et al. for a last / senior author rather than for a first author

Short Story with Cinderella as a Voo-doo Witch



How to delete columns with zero value in each line?



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
2019 Community Moderator Election Results
Why I closed the “Why is Kali so hard” questionHow to remove a column or multiple columns from file using shell command?Cost-efficiently pair each line of a file with all othersarithmetic operation with columns in text fileHow can I replace rows containing ONLY number ' 0' with blank rows using AWK?How to selectively remove columns and rows with bash?Delete columns that sum to zeroHow to add commas (based on count in a line, igonoring the comma in the double quote text) at the end of each line?How to insert comma at given location?How to treat a string of a file as a value when run awk?How to read a file line by line then take each line and insert into txt file



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I have a file containing numeric data.
Each line has a varying number of columns. In each line, I want to delete the columns containing 0.



Below is a sample Input



25 60 0
29 0 10
23 0
26 43 49
1 56 7 0
21 0 64 3


Target Output



25 60
29 10
23
26 43 49
1 56 7
21 64 3









share|improve this question









New contributor




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


























    0















    I have a file containing numeric data.
    Each line has a varying number of columns. In each line, I want to delete the columns containing 0.



    Below is a sample Input



    25 60 0
    29 0 10
    23 0
    26 43 49
    1 56 7 0
    21 0 64 3


    Target Output



    25 60
    29 10
    23
    26 43 49
    1 56 7
    21 64 3









    share|improve this question









    New contributor




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






















      0












      0








      0








      I have a file containing numeric data.
      Each line has a varying number of columns. In each line, I want to delete the columns containing 0.



      Below is a sample Input



      25 60 0
      29 0 10
      23 0
      26 43 49
      1 56 7 0
      21 0 64 3


      Target Output



      25 60
      29 10
      23
      26 43 49
      1 56 7
      21 64 3









      share|improve this question









      New contributor




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












      I have a file containing numeric data.
      Each line has a varying number of columns. In each line, I want to delete the columns containing 0.



      Below is a sample Input



      25 60 0
      29 0 10
      23 0
      26 43 49
      1 56 7 0
      21 0 64 3


      Target Output



      25 60
      29 10
      23
      26 43 49
      1 56 7
      21 64 3






      shell-script text-processing






      share|improve this question









      New contributor




      rkatraga 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




      rkatraga 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 10 hours ago







      rkatraga













      New contributor




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









      asked 10 hours ago









      rkatragarkatraga

      175




      175




      New contributor




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





      New contributor





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






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




















          2 Answers
          2






          active

          oldest

          votes


















          0














          Try this,



          sed 's/ 0//g;s/^0 //g' file

          25 60
          29 10
          23
          26 43 49
          1 56 7
          21 64 3


          it just removes the pattern 0. if the output is fine, use -i option to do inline edit.






          share|improve this answer

























          • What if 0 is in the first column?

            – Benjamin W.
            10 hours ago











          • Thank You for the quick response

            – rkatraga
            10 hours ago


















          1














          Using perl:



          $ perl -alne 'print join " ", grep $_ != 0 @F' file
          25 60
          29 10
          23
          26 43 49
          1 56 7
          21 64 3





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



            );






            rkatraga 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%2f512839%2fhow-to-delete-columns-with-zero-value-in-each-line%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









            0














            Try this,



            sed 's/ 0//g;s/^0 //g' file

            25 60
            29 10
            23
            26 43 49
            1 56 7
            21 64 3


            it just removes the pattern 0. if the output is fine, use -i option to do inline edit.






            share|improve this answer

























            • What if 0 is in the first column?

              – Benjamin W.
              10 hours ago











            • Thank You for the quick response

              – rkatraga
              10 hours ago















            0














            Try this,



            sed 's/ 0//g;s/^0 //g' file

            25 60
            29 10
            23
            26 43 49
            1 56 7
            21 64 3


            it just removes the pattern 0. if the output is fine, use -i option to do inline edit.






            share|improve this answer

























            • What if 0 is in the first column?

              – Benjamin W.
              10 hours ago











            • Thank You for the quick response

              – rkatraga
              10 hours ago













            0












            0








            0







            Try this,



            sed 's/ 0//g;s/^0 //g' file

            25 60
            29 10
            23
            26 43 49
            1 56 7
            21 64 3


            it just removes the pattern 0. if the output is fine, use -i option to do inline edit.






            share|improve this answer















            Try this,



            sed 's/ 0//g;s/^0 //g' file

            25 60
            29 10
            23
            26 43 49
            1 56 7
            21 64 3


            it just removes the pattern 0. if the output is fine, use -i option to do inline edit.







            share|improve this answer














            share|improve this answer



            share|improve this answer








            edited 10 hours ago

























            answered 10 hours ago









            msp9011msp9011

            4,70844167




            4,70844167












            • What if 0 is in the first column?

              – Benjamin W.
              10 hours ago











            • Thank You for the quick response

              – rkatraga
              10 hours ago

















            • What if 0 is in the first column?

              – Benjamin W.
              10 hours ago











            • Thank You for the quick response

              – rkatraga
              10 hours ago
















            What if 0 is in the first column?

            – Benjamin W.
            10 hours ago





            What if 0 is in the first column?

            – Benjamin W.
            10 hours ago













            Thank You for the quick response

            – rkatraga
            10 hours ago





            Thank You for the quick response

            – rkatraga
            10 hours ago













            1














            Using perl:



            $ perl -alne 'print join " ", grep $_ != 0 @F' file
            25 60
            29 10
            23
            26 43 49
            1 56 7
            21 64 3





            share|improve this answer



























              1














              Using perl:



              $ perl -alne 'print join " ", grep $_ != 0 @F' file
              25 60
              29 10
              23
              26 43 49
              1 56 7
              21 64 3





              share|improve this answer

























                1












                1








                1







                Using perl:



                $ perl -alne 'print join " ", grep $_ != 0 @F' file
                25 60
                29 10
                23
                26 43 49
                1 56 7
                21 64 3





                share|improve this answer













                Using perl:



                $ perl -alne 'print join " ", grep $_ != 0 @F' file
                25 60
                29 10
                23
                26 43 49
                1 56 7
                21 64 3






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 10 hours ago









                steeldriversteeldriver

                37.9k45489




                37.9k45489




















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









                    draft saved

                    draft discarded


















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












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











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














                    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.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f512839%2fhow-to-delete-columns-with-zero-value-in-each-line%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







                    -shell-script, text-processing

                    Popular posts from this blog

                    Frič See also Navigation menuinternal link

                    Identify plant with long narrow paired leaves and reddish stems Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?What is this plant with long sharp leaves? Is it a weed?What is this 3ft high, stalky plant, with mid sized narrow leaves?What is this young shrub with opposite ovate, crenate leaves and reddish stems?What is this plant with large broad serrated leaves?Identify this upright branching weed with long leaves and reddish stemsPlease help me identify this bulbous plant with long, broad leaves and white flowersWhat is this small annual with narrow gray/green leaves and rust colored daisy-type flowers?What is this chilli plant?Does anyone know what type of chilli plant this is?Help identify this plant

                    fontconfig warning: “/etc/fonts/fonts.conf”, line 100: unknown “element blank” The 2019 Stack Overflow Developer Survey Results Are In“tar: unrecognized option --warning” during 'apt-get install'How to fix Fontconfig errorHow do I figure out which font file is chosen for a system generic font alias?Why are some apt-get-installed fonts being ignored by fc-list, xfontsel, etc?Reload settings in /etc/fonts/conf.dTaking 30 seconds longer to boot after upgrade from jessie to stretchHow to match multiple font names with a single <match> element?Adding a custom font to fontconfigRemoving fonts from fontconfig <match> resultsBroken fonts after upgrading Firefox ESR to latest Firefox