I have a CSV file with multiple columns, comma ", " separated and numbers of lines.
some lines have empty one or two fields "Columns". How I can identify in a separate file and/or remove those line with one or more empty columns with Awk command.
example
aaaa,bbbb,cccc,dddd,
,bbbb,cccc,dddd,
aaaa,,cccc,dddd,
aaaa,,,dddd,
,,,dddd,
The ", ," means empty columns. I tried this command but it did not work!
awk -F, '$1,4~/^$/' filename
The expected output should be only :
aaaa, bbbb, cccc, dddd,