Search Results

Great! Learning slowly but surely. Thanks for all of your help!

awk '{n=0;for(i=2;i<=5;i++) if ($i+0!=0) n++}n' FS=',' myFile

Just changed the format to .csv and the code worked great! Thanks for you patience!

One more question, if I want to put the...

When I run this code, it removes all rows with any zeros in columns 2-5 (e.g. 0 0 1 1 or
0 1 1 1 get removed), not just rows for which there are zeros in every column (e.g. 0 0 0 0 ).

Okay...the data above was just made-up data to avoid the lengthy name of contigs. My data is in a tab delimited text file and looks as follows:
...

This is what I type:

mep74-1:Desktop morganmouchka$ awk '{n=0;for(i=2;i<=5;i++) if ($i+0!=0) n++}n' FS=',' AT_counts.txt

And nothing prints on the screen and it directs me to the next command...

When I run this script nothing seems to happen? Is the output being directed somewhere? Sorry for my ignorance.

When I run this script (from rdrtx1), it seems to have taken out all of the rows that have any zeros and not just rows for which all four columns have zeros. Also, is there a way to print the data...

Hello,

I have a very large file for which I would like to remove all rows for which the value of columns 2-5 is zero.

For instance I would like this file:
contig1, 0, 0, 0, 0
contig2, 1,...