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 ^@.