Shell Programming and Scripting

Hi all,
I have an requirement related to delim count. I want to remove the lines having less than or equal to 2 fields in a csv file. In other words, I want to retrieve the records having more than 2 fields.

I can do this using a loop with tr and wc -l command by parsing record by record. But, my file looks like a huge one. Any faster way of doing this? I'm a beginner in awk or sed. Pls help me.

Thanks in advance,
Poova.

Do you know the delim? If yes:

Code:

awk -F"<delim>" '{if(NF>2){print $0}}' <InputFile> > <OutputFile>

Regards.

If the file is a space/tab separated file:

Code:

awk 'NF>2' file

Otherwise:

Code:

awk -F"your field delimer here" 'NF>2' file

Thanks a lot. really useful.