Is there an awk or sed to remove invalid rows ?

[grinder332518]

I have a file with rows with 10 columns, separated by 9 “|” (pipe) separators.

However, every now and again, I am getting spurious rows appearing with no separators at all, or other rows appearing with fewer than the 9 separators.

There is no way for me to prevent them from appearing from within the application,

So, my question is, is there an awk command, or, preferably, a sed command, which anyone can provide which will strip out these non-standard rows ??

Many thanks in advance.

[Mariostg]

You could use the NF (number of field) variable of awk.

FS="|"
if (NF == 10) {
  Do your stuff;
} else  {
  Do something else;
}