Delete records from a big file based on some condition

view story

http://www.unix.com – Hi, To load a big file in a table,I have a make sure that all rows in the file has same number of the columns . So in my file if I am getting any rows which have columns not equal to 6 , I need to delete it . Delimiter is space and columns are optionally enclosed by "". This can be identified like this : COLUMN_1 COLUMN2 COLUMN_3 COLUMN4 COLUMN_5 COLUMN6 Correct Records : 123 1 3 test "abc def test" 200 234 1 3 "test" "abc def test" 200 456 1 3 "test" "abc def test" "abc 200" Records to be deleted fro (HowTos)