bash how to remove rows if specific field is blank
# Basic syntax:
awk -F'delimiter' '$column# != ""' input_file
# Example usage:
awk -F'\t' '$3 != ""' input_file
# This prints every line in which the 3rd tab-delimited column is
# not blank. Change the 3 to any column and/or add other conditions
# for your application