Need to replace special character ^@ with a space

[Ratzie]

I have file that has certain records failing to load because of a funky character. I need to replace this character with a space.

Can not copy paste, or grep, or sed this character.
I have attached a blurb of the file, this is a rather large file and only taken a few lines of the file.
Could not find any google on it.
Thanks for the help.

[A. Clay Stephenson]

I'll assume your ^@ is an ASCII NUL (octal 000); if not, do an od -c yourfile | pg to identify the octal value of your character.

tr "\000" " " < oldfile > newfile

[H.Merijn Brand (procura · Accepted solution]

# perl -pi -e'y/\0/ /' file

Enjoy, Have FUN! H.Merijn

[Ratzie]

Excellent!
Thanks for the help!