help needed for simple unix command

[DeltaFun]

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

[marist89]

man sed

[adrianomp]

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

[DeltaFun]

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

DF

[adrianomp]

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.

[DeltaFun]

Thanks very much for all your help.

[TomazZ]

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