DSXchange

The unix command to see the incomplete records.
awk -F"\t" '{if (NF != 13) print NR,NF,$0}' filename.txt|more

This is good for txt files.
But what is the command for zipfile.
filename.gz(format)

Could any one please help.

You'll have to gunzip the file and pipe the output to awk.

gunzip -c file.gz |awk '{print $1}'|more

I am not sure if I am using it right or not. When I use this command it says file is too large

Then it's too large. It may be too large for more (you could experiment). Otherwise you need to unzip to disk and run awk over that. Use redirection operators - you could add an rm command to the end of the pipeline of commands.

gunzip -c file.gz | awk -F"\t" '{if (NF != columncount ) print NR,NF,$0}'


This command worked for the large files too. I did close the Unix box and re-opened and used the command again it did work.

Thanks for your help