I have a tab delimited file with column headers like ID, A, B, C, D as shown in the pic below, and row labels too like a, b, c, d, e show below in pic. How do I remove all the empty lines (rows) while preserving the row labels with non-empty rows? Example input and desired output is shown below. Thank you for any help!
Sample input:
ID A B C D a 1 2 b c 1 1 d e 1 Desired output:
ID A B C D a 1 2 c 1 1 e 1 [sample input and output transcribed from original image]
What I suggest:
$ awk 'NF>1' file I A B C D a 1 2 c 1 1 e 1 
-F'\t' for clarity (although the default FS of course also includes TAB in "contiguous runs of whitespace"). b\t\t\t\t), awk -F '\t' would see the empty columns there and NF would be set accordingly. Then you'd need to loop over $2 to $NF to see if any of them is non-empty. Using sed or grep
$ sed -En '/[^ \t]*[ \t]/p' input_file ID A B C D a 1 2 c 1 1 e 1 $ grep -E '[^ \t]*[ \t]' input_file ID A B C D a 1 2 c 1 1 e 1 
{}