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?