Special character ^@ in CSV file

All,

I am having a tough time with Linux and CSV file. My CSV file gets generated from Cognos on Linux machine that contains special characters. At first instance when I do vi <filename> to that file, I can't see anything. I did tail -2 and redirected to another temp file and did vi <filename> , I can see control characters ^@. I can remove those characters manually by using :%s/^@//g in vi editor. But, the process need to be done automatically as its all automated. Its needs to be done from shell script. The same file came with some other special character in Solaris and was easy to remove.

Any help would be appreciated.

why dot you try tr, sed or awk to replace the special character in your script?

worst case u can do

 
vi - you_file_name<<!
:%s/^@//g
:wq
!

@Vidya

I did try sed but got error every time. Your solution might help...

Thanks...