Problem translating dbl quotes with sql loader
I have a data file that has intermittent double quotation marks in it that I want to translate to something else, like a "-". I haver used the sqlldr and the TRANSLATE command to convert other values, but sqlldr seems to problem with the ".
Here is the command that I am using
WELL_NAME "translate(:WELL_NAME,'"','-')",
This is the error:
SQL*Loader-350 Syntax error at line 25.
Expecting ",' or ")", found ",".
WELL_NAME "translate(:WELL_NAME,'"','-')",
I have tried escaping the " with a \, but that did not work either.
Can anyone help?