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;
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
New contributor
add a comment |
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
New contributor
add a comment |
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
New contributor
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
shell-script text-processing
New contributor
New contributor
edited 10 hours ago
rkatraga
New contributor
asked 10 hours ago
rkatragarkatraga
175
175
New contributor
New contributor
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
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.
What if0
is in the first column?
– Benjamin W.
10 hours ago
Thank You for the quick response
– rkatraga
10 hours ago
add a comment |
Using perl:
$ perl -alne 'print join " ", grep $_ != 0 @F' file
25 60
29 10
23
26 43 49
1 56 7
21 64 3
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
What if0
is in the first column?
– Benjamin W.
10 hours ago
Thank You for the quick response
– rkatraga
10 hours ago
add a comment |
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.
What if0
is in the first column?
– Benjamin W.
10 hours ago
Thank You for the quick response
– rkatraga
10 hours ago
add a comment |
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.
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.
edited 10 hours ago
answered 10 hours ago
msp9011msp9011
4,70844167
4,70844167
What if0
is in the first column?
– Benjamin W.
10 hours ago
Thank You for the quick response
– rkatraga
10 hours ago
add a comment |
What if0
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
add a comment |
Using perl:
$ perl -alne 'print join " ", grep $_ != 0 @F' file
25 60
29 10
23
26 43 49
1 56 7
21 64 3
add a comment |
Using perl:
$ perl -alne 'print join " ", grep $_ != 0 @F' file
25 60
29 10
23
26 43 49
1 56 7
21 64 3
add a comment |
Using perl:
$ perl -alne 'print join " ", grep $_ != 0 @F' file
25 60
29 10
23
26 43 49
1 56 7
21 64 3
Using perl:
$ perl -alne 'print join " ", grep $_ != 0 @F' file
25 60
29 10
23
26 43 49
1 56 7
21 64 3
answered 10 hours ago
steeldriversteeldriver
37.9k45489
37.9k45489
add a comment |
add a comment |
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.
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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