help needed for simple unix command

Hi, all
I have a file to load into oracle database, in my source file, there are " " on the numbers, for instance, "12345", I need to get rid of the " ", but don't know the command, could someone help me, Thanks.
The file is too big, have to do on unix platform.
DF

man sed

Didn't see your point. You want just to truncate all the spaces in the file? Try this:

sed 's/ //g' source_file > dest_file
mv dest_file source_file

what I want is change "12345" to 12345. Thanks.

DF

Well, you can remove all the symbols with:

sed 's/\"//g' source_file > dest_file

Otherwise, you'll have to run several commands like:

sed 's/\"1/1/' source_file > dest_file_1
sed 's/1\"/1/' dest_file_1 > dest_file_2
sed 's/\"2/2/' dest_file_2 > dest_file_3
.
.
and so on. Do as Jeff said, "man sed" and run it as a loop in a shell script.

Thanks very much for all your help.

If you will load it with sqlldr, you don't have to pre-parse the file, just use optionally enclosed by '"'