File conversion and removing special characters from a file in Linux

I have a .CSV file when I check for the special characters in the file using the command

cat -vet filename.csv

, i get very lengthy lines with "^@", "^I^@" and "^@^M" characters in between each alphabet in all of the records. Using the code below

file filename.csv

I get the output as

I have a script to remove the control M (^M) from the file, whose output returns me an error saying : cannot execute binary file.

I know that ^I represent a tab. I also have a script to convert ^I to comma delimited file but Can anyone help me format the file with respect to the error and also ^@.

use tr or try strings command to only get printable chars.

Check if you have man iconv (linux) available.