Hi,
I have a tabular txt file with 105078 rows and 22 columns I want to remove all those lines if 50 percent of columns (columns 3 - 22) has empty fields.
I tried ISBLNAK and IF function in excel, no luck. Could awk or sed help me?
Regards,
Waqas.