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.
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,