Removing weird characters (^@)

[emilybartholomew]

Hi-

I am currently trying to extract all the data from an Oracle db and upload it into a mysql db. I ran SQL queries in SQL Plus to get all the data, spooling the output to a txt file. Now I'm trying to upload the data into the new db (using a perl script), but there are these weird characters in the data files. Every so often I get these "^@^@^@^@^@^@^@^..." in the data. Is there a way to use a regular expression to get rid of these?!

Thnx

 

[justice41]

That's the null character. You can use

$string =~ tr/\x00//d;

to strip them out.

jaa

 

[emilybartholomew]

thanks!