awk help to print lines when the columns are non zeros
Hi I have a file with the following format:
filename is foo.txt
abcd 1 0 0 2
abef 2 0 0 0
able 2 1 2 0
able 1 0 0 0
efgh 0 0 0 0
I wrote an awk script to delete the row with all columns with 0. But I am getting syntax error. SO I am sure this is very simple.
Please can anytime help me fix this?
awk 'BEGIN{i=1; While($2==0)($3==0)($4==0) {print $0} }' foo.txt
• 1,617 views
•
link
updated
by
Ram
•
written
by
geneart$$ •
•
written
by
geneart$$ •
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Max length reads from fastq
written by marco.barr •
-
why the syntax error comes when i use the same command in loop in bash linux
written by Priya •
-
How to get sample names and genotype for SNP in multi-sample VCF file with special occurence
written by User000
-
How to make fasta manipulation more efficient
written by c_u
-
Problems awking columns from map file
written by Nuthatch •
-
Running a code in batch mode on a list of files
written by zizigolu
-
Help with awk loop
written by Francisco Muñoz •
-
blast alignemnt query coverage using perl
written by sharmatina189059 •
-
Reformat a table with awk
written by viv3kanand •
-
Gnu Parallel Quoting With Awk
written by tayebwajb
Hello compugene!
We believe that this post does not fit the main topic of this site.
Not a bioinformatics question
For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.
If you disagree please tell us why in a reply below, we'll be happy to talk about it.
Cheers!
I disagree.
When we get transcripts count file from htseq or refseq etc,it spits out genenames with columns of a value. We would then go ahead and delete lines which has zeros across all columns.
I did not want to post my data set and values on the post and hence gave random names.
It is bioinformatics text processing and hence extremely relevant.
Please post it back on.
Much appreciated,
Thanks.
You should have mentioned this part on transcript counts. We can only work with the context you give us. You said you have a "file" with some kind of data in it that you wish to process with a generic unix tool - how does this relate to bioinformatics?
Strictly speaking, unless it needs some sort of domain knowledge, this is just plain text processing. Text processing is a large part of what we do, but just because something is text processing does not make it bioinformatics.
The onus is on you to make a question relate to bioinformatics, not on moderators to imagine how random posts could be bioinformatics.
Also to add to my previous email. There is tons of text processing that happens in NGS and it is important to somehow link computational questions to bioinformatics/ngs portal. If this does not fit the realm currently, I strongly feel one should come up with one such,unless there is a portal already. Thanks Best
Yes, there is, but stackoverflow and other sites already address most text processing challenges. A quick google turned up a result to an expanded version of your question: https://stackoverflow.com/questions/37976535/awk-unix-command-how-to-delete-rows-when-multiple-column-having-zero-values
To reiterate, please edit your question and give some context to establish your post as relating to bioinformatics, and then your question will be reopened.
Ok sure, thanks Kshama.