I need to read the file (contains 16K rows)and print the entire row if any of columns and all columns contains max value (100) and all columns contain min value (0).The ouput example is given
input.txt (tab-delimited)
Id sno1 sno2 sno3 sno4
E1 98 100 88 78
E2 33 99 78 66
E3 0 0 100 56
E4 0 0 0 0
E5 45 55 65 100
E6 0 0 99 88
E7 100 100 100 100
Ouput.txt
E1 98 100 88 78
E3 0 0 100 56
E4 0 0 0 0
E5 45 55 65 100
E7 100 100 100 100